Thread: Need help asap
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default Need help asap

If you have two dates in A1 and B1, then you can enter this formula in
C1:

=ABS(A1-B1)/365

and format C1 as a number. This will give you the difference in the
dates in years (approximately, as there are 365.25 days in a year on
average).

Hope this helps.

Pete