| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating Age NOT as of today but as of a date in the future or
I often need to calculate student age as of a specific date.
For example: A1: DOB A2: age as of Sept 30, 2010 I need a formula that will also work if I need to choose a date in the past too, such as: age as of Sept 30, 2007 Thanks in advance for your help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating Age NOT as of today but as of a date in the future or
One way could be:
=IF(A1<A2,DATEDIF(A1,A2,"y"),DATEDIF(A2,A1,"y")) Micky "Deb" wrote: I often need to calculate student age as of a specific date. For example: A1: DOB A2: age as of Sept 30, 2010 I need a formula that will also work if I need to choose a date in the past too, such as: age as of Sept 30, 2007 Thanks in advance for your help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating Age NOT as of today but as of a date in the future
http://www.cpearson.com/excel/datedif.aspx
-- HTH... Jim Thomlinson "מיכאל (מיקי) אבידן" wrote: One way could be: =IF(A1<A2,DATEDIF(A1,A2,"y"),DATEDIF(A2,A1,"y")) Micky "Deb" wrote: I often need to calculate student age as of a specific date. For example: A1: DOB A2: age as of Sept 30, 2010 I need a formula that will also work if I need to choose a date in the past too, such as: age as of Sept 30, 2007 Thanks in advance for your help. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating Age NOT as of today but as of a date in the future
Thanks! This worked perfect!!
"מיכאל (מיקי) אבידן" wrote: One way could be: =IF(A1<A2,DATEDIF(A1,A2,"y"),DATEDIF(A2,A1,"y")) Micky "Deb" wrote: I often need to calculate student age as of a specific date. For example: A1: DOB A2: age as of Sept 30, 2010 I need a formula that will also work if I need to choose a date in the past too, such as: age as of Sept 30, 2007 Thanks in advance for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating a future date using system clock & time remaining | Excel Worksheet Functions | |||
| Problem with calculating date 6 months into the future | Excel Worksheet Functions | |||
| Calculating a future date | Excel Discussion (Misc queries) | |||
| Calculating a Date for the Future | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Linear Mode
