If you want to calculate how much time is left until a certain expiry date, you can use the DATEDIF function. This function returns the difference between two dates in terms of days, months, or years.

Excel’s Date & Time functions ease the workload for bookkeepers, project planners, HR departments, and other jobs where time is money. The four functions covered here—ISOWEEKNUM, WEEKNUM ...

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.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.

Open a new Microsoft Excel 2010 spreadsheet. Click on cell A1 and enter the earliest date and time from where you want to count. Enter the date first, then press "Space" and enter the time using a ...

Enter the payment dates in column B, using the DATE function to ensure proper formatting. The format for DATE is Year,Month,Day. For example, to enter the date of June 1, 2013, type:=DATE (2013,6,1) ...

To calculate IRR in Excel, you can use the Insert Function command to add the IRR function. The syntax for the three different IRR functions in Excel are: =IRR (values, [guess]) ...