View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
hellZg8
 
Posts: n/a
Default 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