Date Calc.

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

Hi all,

How do i do a date calculation that will return partial
years? I have been using Dated Ifs and I only get whole
years answers.

DATEDIF(6/16/2000,01/16/03,"y") Returns 2

I need a formula to return 2.5. Can excel do this or do I
have to write the formula myself?


TIA

Todd
 
Todd,

You could use the following

=DATEDIF("June 16, 2000","January 16, 2003","M")/12

Datedif to return the months/12MperY

Dan E
 
Back
Top