calculate age

springtime

New Member
Joined
Aug 28, 2002
Messages
1
I need a formula that will calculate customers age. I also need this formula to give me some type of warning when a person reaches a certain age.
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,459
To calculate by years,

A1 house birthday

=datedif(a1,today(),"Y")

What kind of warning would you like to use?
 

manney

New Member
Joined
Mar 25, 2002
Messages
46
Assuming 2 dates, Date 1 (in Cell A1) and Date 2 (in Cell A1)(Date 1 is the person's birthday, for example, and date2 might be today's date)...

In Cell A3, type the formula--

=YEAR(A2)-YEAR(A1)

This will return the years bewween the dates. In Cell A4, type the formula--

=IF(A3>50,"Too Old","Young Enough")

...where "50" is the age you're testing against. This age could be in another cell, and the formula could refer to it. The formula would then become (assuming the age is, say, in A10)...

=IF(A3>$A$10,"Too Old","Young Enough")

Hope this helps.
pmanney@oriuscorp.com
 

Forum statistics

Threads
1,147,508
Messages
5,741,570
Members
423,668
Latest member
Audorin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top