Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
advance number by 1 when compared
Need Formula concerning birthday.
I would like to advance a persons age by one (1) if the current day is equal to or greater than the birthday date. I'm trying to advance a person's age by one (1) when comparing someone's birthday to the current date. I only want this done one time for the entire year. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
advance number by 1 when compared
Hi,
Try this =DATEDIF(A1,TODAY(),"y") Where A1 is the DOB. You won't find Datedif in Excel help because it isn't documented. Look here for help on the subject http://www.cpearson.com/excel/datedif.htm Mike "Edwin Armstrong" wrote: Need Formula concerning birthday. I would like to advance a persons age by one (1) if the current day is equal to or greater than the birthday date. I'm trying to advance a person's age by one (1) when comparing someone's birthday to the current date. I only want this done one time for the entire year. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
advance number by 1 when compared
=IF(birthdate cell<=now(),agecell+1,agecell)
"Edwin Armstrong" wrote: Need Formula concerning birthday. I would like to advance a persons age by one (1) if the current day is equal to or greater than the birthday date. I'm trying to advance a person's age by one (1) when comparing someone's birthday to the current date. I only want this done one time for the entire year. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a template form, advance a form number everytime you open | Excel Discussion (Misc queries) | |||
Performance compared to an index using XIRR | Excel Worksheet Functions | |||
Is there a way to automatically advance a number when printing? | Excel Worksheet Functions | |||
ISMPT compared to Amortization | Excel Worksheet Functions | |||
Can I disable this automatic number advance thing? | Excel Discussion (Misc queries) |