Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
calculating ages from dates before 1900
Thanks in advance once again. I'm trying to caluculate some ages using a formula recommended in some earlier posts. I like the format given in three numbers, representing years, months and days. I'm using this currently. =DATEDIF(B1,G1,"y") & " " & DATEDIF(B1,G1,"ym")&" "& DATEDIF(B1,G1,"md") my problem is, some of the birthdates are before 1900 and I get the infamous #VALUE for an answer. Is there a way to use dates before 1899 or so? Thanks again, JasonK |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating average ages | Excel Discussion (Misc queries) | |||
Calculating ages and volumes: Macro or formula? | Excel Programming | |||
Calculating ages | Excel Discussion (Misc queries) | |||
calculating ages | Excel Worksheet Functions | |||
Calculating Ages from Birthdates | Excel Discussion (Misc queries) |