VB Forum / COM / September 2004

Since both months and years may have a variable number of days, it's
hard to say. If you use the DateAdd method, you can get just about any
info you need (like days or months or years between any 2 dates)

Hi,
   If you have a number of days, like 734 (versus an actual date) you can
get the years and months
by doing:

years = datediff("yyyy",0,numDays)
months = datediff("m",0,numdays)

It won't be 100% accurate because of leap years, and all, but it should be
pretty close.

Lance

Hi

Has anyone got an easily formula to convert the number of days to a value
with years and months??