how long date difference
I actually did spell check so feburary was actually spelled correctly
I tried the =datedif(a1,b1,Y) got #name? in cell c1
a1= startdate
b1 =now()
c1=how many years in a number format with one decimal
place representing the months
eg.. 19 years 4 months = 19.4
formatting of the cells a1 & b1 are date with mmmm dd,yyyy
and c1 is number
|