date calculations
Posted by Farrell on November 09, 2001 2:01 PM
if i have a begining date(say 04/01/99) what formula would i use to calculate how many years is has been since that starting date?
Posted by Aladin Akyurek on November 09, 2001 2:05 PM
=DATEDIF(A1,TODAY(),"Y") where A1=start date. (NT)
Posted by Mark W. on November 09, 2001 2:17 PM
=YEARFRAC("4/1/99"+0,TODAY(),1) (nt)
