Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW TO CALCULATE AGE AS OF A CERTAIN DATE?
I need to create a formula to calculate age as of 04-30-10. Can anyone help
me? I am using Excel 2007. |
#2
|
|||
|
|||
Answer: HOW TO CALCULATE AGE AS OF A CERTAIN DATE?
To calculate age as of a certain date in Excel 2007, you can use the
Code:
DATEDIF
The formula will display the age in years, months, and days. For example, if the birthdate is 01/01/1990 and the current date is 04/30/2010, the formula will display "20 years, 3 months, 29 days".
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW TO CALCULATE AGE AS OF A CERTAIN DATE?
=DATEDIF(A1,B1,"y")
with variable date in A1 and today's date in B1 Look he http://www.cpearson.com/excel/datedif.aspx -- Kind regards, Niek Otten Microsoft MVP - Excel "BB" wrote in message ... I need to create a formula to calculate age as of 04-30-10. Can anyone help me? I am using Excel 2007. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW TO CALCULATE AGE AS OF A CERTAIN DATE?
<today's date
Make that your "certain date" -- Kind regards, Niek Otten Microsoft MVP - Excel "Niek Otten" wrote in message ... =DATEDIF(A1,B1,"y") with variable date in A1 and today's date in B1 Look he http://www.cpearson.com/excel/datedif.aspx -- Kind regards, Niek Otten Microsoft MVP - Excel "BB" wrote in message ... I need to create a formula to calculate age as of 04-30-10. Can anyone help me? I am using Excel 2007. |
#5
|
|||
|
|||
This was extremely helpful for me as well. Thanks!
Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate within a time range with only start date and end date | Excel Worksheet Functions | |||
Trying to calculate end date using order date and lead time variab | Excel Worksheet Functions | |||
Auto calculate for date + days forward to yield new date | Excel Worksheet Functions | |||
formula to calculate age using birth date and current date | Excel Worksheet Functions | |||
formula to calculate future date from date in cell plus days | Excel Worksheet Functions |