| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Evaluate Date for 21st birthday
Our Medical Records needs to thin out charts after residents 21st birthday
and or 10 years after last date of service. I'm having trouble with the formula and keep going in circles, with leap years tripping me up. Help please. Thanks, Karalee |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Evaluate Date for 21st birthday
Take a look at DateDif, http://www.cpearson.com/Excel/datedif.aspx
-- __________________________________ HTH Bob "Karalee" wrote in message ... Our Medical Records needs to thin out charts after residents 21st birthday and or 10 years after last date of service. I'm having trouble with the formula and keep going in circles, with leap years tripping me up. Help please. Thanks, Karalee |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Evaluate Date for 21st birthday
This will result in a TRUE or FALSE argument
=OR(DATEDIF(DOB,todaysdate,"y")=21,DATEDIF(LDOS,t odaysdate,"y")=10) DOB=date of birth LDOS=Last Date of Service todaysdate=Effective date of purge (assuming you could use TODAY() or something similar). -- ** John C ** "Karalee" wrote: Our Medical Records needs to thin out charts after residents 21st birthday and or 10 years after last date of service. I'm having trouble with the formula and keep going in circles, with leap years tripping me up. Help please. Thanks, Karalee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate date - 1st of the month following 65th birthday - EXCEL | Excel Discussion (Misc queries) | |||
| Format cells to display ordinal numbers ex 21st | Excel Worksheet Functions | |||
| Can anyone calculate age next birthday from date field? | Excel Worksheet Functions | |||
| Birthday date formula? | Excel Worksheet Functions | |||
| exel 2000 st in 21st to move up | Excel Discussion (Misc queries) | |||
Linear Mode
