| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
convert date of birth to mos. old now, 30 and 60 days
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. |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert date of birth to current age | Excel Worksheet Functions | |||
| How to convert string to a date | Excel Worksheet Functions | |||
| extract numbers, convert to date | Excel Discussion (Misc queries) | |||
| convert julian date to gregorian date | Excel Discussion (Misc queries) | |||
| How do I convert a Julian date into a regular date? | Excel Discussion (Misc queries) | |||
Linear Mode
