convert date of birth to mos. old now, 30 and 60 days

S

Samantha

I have a function to convert date of birth to # of months old as of today,
but need the function to convert date of birth to # of months old in 30 days,
in 60 days, in 90 days, etd.
 
R

Ron Rosenfeld

I have a function to convert date of birth to # of months old as of today,
but need the function to convert date of birth to # of months old in 30 days,
in 60 days, in 90 days, etd.
Click to expand...

What's a month?

DATEDIF may be accurate enough for you:

=DATEDIF(dob,TODAY(),"m")

=DATEDIF(dob,TODAY()+30,"m")

=DATEDIF(dob,TODAY()+60,"m")

etc.


--ron
 
Top