You already knew that Excel can do straight date math, but it can also take into account holidays to find the number of working days between two dates. Tech blogger Chandoo points out the =networkdays ...

In Excel a "Vlookup," short for vertical lookup, is a formula used to return a value from a table of data. For example, you might want to add a column to a customer information spreadsheet that tells ...

To calculate the returns on your mutual fund investments made on different dates, using XIRR formula in excel makes the task easier. You may be investing through SIP or making lump sum investments on ...

Q. When I paste a large amount of data into Excel containing dates as far back as the 1800s, the recent dates display correctly as valid dates, but the older dates automatically convert to text. I ...