| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
calculate age using BD and (TODAY)
I would like to have the current age calculated in an excel spread sheet and
am having trouble with the formula. Any help appreciated. TIm |
|
#2
|
|||
|
|||
|
=YEAR(B1)-YEAR(A1)
will give you age in whole number. Regards. Bill Ridgeway Computer Solutions "Tim" wrote in message ... I would like to have the current age calculated in an excel spread sheet and am having trouble with the formula. Any help appreciated. TIm |
|
#3
|
|||
|
|||
|
"Bill Ridgeway" wrote in message
... =YEAR(B1)-YEAR(A1) will give you age in whole number. Not quite. Suppose the DoB was 31st December? The *age* would be a year out for all but one day of the year. The DATEDIF function will calculate the age. DATEDIF is only in XL2000 Help but Chip Pearson has a page on his website about it: http://www.cpearson.com/excel/datedif.htm =DATEDIF(A1,B1,"y") Note that it takes the arguments: earliest date then later date -- HTH Sandy Replace@mailinator with @tiscali.co.uk |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to calculate a date .. say 34 days from today | Excel Discussion (Misc queries) | |||
| formulas won't calculate | Excel Worksheet Functions | |||
| Count the number of dates in a range that are earlier than today. | Excel Worksheet Functions | |||
| Excell Files attached to emails are suddenly not readable today. . | Excel Discussion (Misc queries) | |||
| How do I stop today() from updating date on saved spreadsheets? | Excel Discussion (Misc queries) | |||
Linear Mode
