On Mon, 29 Aug 2005 14:51:18 -0700, "Samantha"
wrote:
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.
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
|