View Single Post
  #2   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

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