excel year to decimal

[autex]

how do i get excel to calculate the exact difference between two dates? datediff() is wierd, the diff between 12/31/2001 and 1/1/2002 is one year. months is similar where it's possible for a difference of one day to equal one month. I've thought about converting from days, but then you got leap year to worry about.

What function would you use to calculate the difference between a date in an excel cell and a date entered by the user on a user form?

 

[PHV]

Divide the number of days by 365.245

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[autex]

I thought about that, but that's not exact for obvious reasons. It does work if I round to 2 decimals. let me ask: why 365.245 and not 365.25?

 

[PHV]

Because year ending with 00 aren't leap except if multiple of 400.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Zathras]

Pardon me, but a date is just a number representing the number of days from a base year (1900 or 1904). So the number of days between two dates is just
[tt]
=DATE1-DATE2
[/tt]
(Round or truncate as appropriate if there is any time component.) Or what am I missing?

 

[PHV]

Or what am I missing
I think the OP want a decimal number of year...