Given a date how do i in excel calculate the number of years
P Pete_UK Apr 4, 2008 #2 If you mean the difference between that date and today's date, then you can use the DATEDIF function. However, it is only included in Excel Help for version 2000, but fortunately Chip Pearson explains how to use it here: http://www.cpearson.com/excel/datedif.aspx Hope this helps. Pete
If you mean the difference between that date and today's date, then you can use the DATEDIF function. However, it is only included in Excel Help for version 2000, but fortunately Chip Pearson explains how to use it here: http://www.cpearson.com/excel/datedif.aspx Hope this helps. Pete
