DATEDIF(), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000, which is the only version that explains how this function works. It’s operational in all Excel versions, but it’s not on the Formulas menu or in the Help menus after Excel 2000. If your spreadsheet experiences began with Lotus, which is true for many thousands of users, you’ll be happy to know that this old Lotus function is still alive and kicking. The purpose of this function is to calculate the time between a user-specified starting and ending date in days, months, or years. The arguments for this function are: Start_date: start date in Excel date serial number format End_date: end date in Excel date serial number format Unit: the time unit to use (years, months, or days) And the syntax looks like this: =DATEDIF(start_date,end_date,unit) The “unit” is specified using the unit argument, which is a text code.

DOWNLOAD Excel Key 7.0.1180 SERIAL NUMBER The serial number for Excel is available This release was created for you, eager to use Excel Key 7.0.1180 full and with without limitations.