To ensure that Excel converts your date to a number enter it like this, without quotes: "4/4/2011". Then click on cell "A2" and enter the later of the two dates in the same manner.

Excel will calculate the number of days between the dates entered in cells B3 and A3 and display the result in cell C3. Take your mouse pointer to the lower-right corner of cell C3.

Just replace the number 50 with the cell number where the figure is located. Image used with permission by copyright holder For more on Excel's other functions, check out our guides on how to use ...

How to Calculate Hours in Excel Excluding Weekends. An Excel spreadsheet can become an indispensable tool for your business when you harness its power for keeping records and doing computations.

How to Calculate NPV in Excel Using XNPV Function . To calculate the NPV of an investment project, you must consider the present value of all cash receipts and all cash disbursements related to ...

A straight ranking result is easy using one of Microsoft Excel’s ranking functions. Calculating a conditional rank is even easier if you let an Excel PivotTable do all the work.

How to make a conditional running total in Excel At this point, you’ve not really gained much; the PivotTable isn’t really any better than the Table and its simple expressions.