Working with dates in formulas

[Sharon L Duscher]

I need two different kinds of date calculations.
1. I need to be able to show what age someone is today.
Date of Birth is a field, but they want to show the
current age and I can't get it to work.
2. I have a date and I need to add 7 months to it and
have it come up automatically.
Thanks for your help.

 

[Chip Pearson]

Sharon,

You can use the DATEDIF function to determine an age. See
www.cpearson.com/excel/datedif.htm for more details.

To add a number of months to the date in A1, use a formula like

=DATE(YEAR(A1),MONTH(A1)+7,DAY(A1))

 

[Dan E]

Sharon,

In response to your first question...

If A1 held the birthdate
=DATEDIF(A1,TODAY(),"Y")

For more information on the DATEDIF function see
http://www.cpearson.com/excel/datedif.htm

In response to your second question...

If A2 held the date
=DATE(YEAR(C27), MONTH(C27)+7, DAY(C27))

Dan E