| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I get an age using todays date and date of birth?
I'm using a spreadsheet where I need ages listed. Is there a formula that
can be used to compute the age if I use todays date and date of birth? So far I am not having any luck. Thanks for any help you may provide. I am using Excel 2000. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I get an age using todays date and date of birth?
assuming the birthdate is in cell A1
=YEAR(NOW())-YEAR(A1) "tjw1313" wrote: I'm using a spreadsheet where I need ages listed. Is there a formula that can be used to compute the age if I use todays date and date of birth? So far I am not having any luck. Thanks for any help you may provide. I am using Excel 2000. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I get an age using todays date and date of birth?
Actually, I don't think that last formula will work under certain
circumstances. You should check out the DATEDIF formula in excel help. For the "end date" part of the formula, use TODAY() which will dynamically put in today's date. "tjw1313" wrote: I'm using a spreadsheet where I need ages listed. Is there a formula that can be used to compute the age if I use todays date and date of birth? So far I am not having any luck. Thanks for any help you may provide. I am using Excel 2000. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I get an age using todays date and date of birth?
Dave Peterson - Thank you! The web site you suggested worked great!
"Dave Peterson" wrote: Take a look at Chip Pearson's site for =DateDif() http://www.cpearson.com/excel/datedif.htm tjw1313 wrote: I'm using a spreadsheet where I need ages listed. Is there a formula that can be used to compute the age if I use todays date and date of birth? So far I am not having any luck. Thanks for any help you may provide. I am using Excel 2000. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sum a range if the date is is greater than today's date? | Excel Worksheet Functions | |||
| Setting traffic lights based on todays date against target dates | Excel Discussion (Misc queries) | |||
| Activating "Todays Date" column upon opening? | Excel Discussion (Misc queries) | |||
| how to use today's date in a equation to caculate somebody's birth | Excel Discussion (Misc queries) | |||
| calculate no. of years between a date and today's date | Excel Worksheet Functions | |||
Linear Mode
