| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel Formula, who will be age 55 by 12/31/2007 and 6/30/2009?
It's for my project. I need the formulas to input the data. Please help!!!
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula, who will be age 55 by 12/31/2007 and 6/30/2009?
Clearly anyone born on or before 12/30/1952 will be 55 by 12/31/2007
and anyone born on or before 6/29/1954 will be 55 by 6/30/2009 Put DOB and 12/30/1952 in A1,B1 and use =IF(A1<=B1,"yes","no") first case Put DOB and 6/29/1954 in A1,B1 and use =IF(A1<=B1,"yes","no") next case -- Gary's Student "Containsmiles" wrote: It's for my project. I need the formulas to input the data. Please help!!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel Formula, who will be age 55 by 12/31/2007 and 6/30/2009?
Check Chips' site www.cpearson.com for the use of DATEDIFF
-- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Containsmiles" wrote in message ... It's for my project. I need the formulas to input the data. Please help!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I determine who will be age 55 by 12/31/2007 and 6/30/2009? | Excel Worksheet Functions | |||
| #VALUE error with XIRR | Excel Discussion (Misc queries) | |||
Linear Mode
