| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula for # of days between two dates-Excel 2000
I want to know which employee is 19 years old or older based on a 365 day
year. Can't figure it out. Please help. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula for # of days between two dates-Excel 2000
=DATEDIF(DOB,TODAY(),"y")=19
will return TRUE if 19 and older -- Regards, Peo Sjoblom "kelley" wrote in message ... I want to know which employee is 19 years old or older based on a 365 day year. Can't figure it out. Please help. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to find the working days difference between to dates? | Excel Discussion (Misc queries) | |||
| FORMULA NEEDED TO COUNT DAYS IN EXCEL BETWEEN DATES | Excel Worksheet Functions | |||
| Formula to calculate number of days between Dates | Excel Worksheet Functions | |||
| formula to find and flag dates older than 30 days | Excel Worksheet Functions | |||
| formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
Linear Mode
