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.

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.

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.