| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Age in years only
I need a formula that will just return age in years from a given birthdate. I
have tried using =DATEDIF(A1,TODAY(),"y") but if I do not insert a birthdate then the formula returns 106 -- Jamie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Age in years only
=if(a1="","",datedif(....))
Jamie wrote: I need a formula that will just return age in years from a given birthdate. I have tried using =DATEDIF(A1,TODAY(),"y") but if I do not insert a birthdate then the formula returns 106 -- Jamie -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Age in years only
A blank cell is treated as 1/1/1900 which is 106 years ago.
If you want a blank returned, you could do something like =IF(ISBLANK(A1),"",DATEDIF(A1,TODAY(),"y")) Dave -- Brevity is the soul of wit. "Jamie" wrote: I need a formula that will just return age in years from a given birthdate. I have tried using =DATEDIF(A1,TODAY(),"y") but if I do not insert a birthdate then the formula returns 106 -- Jamie |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Age in years only
Hi Jamie,
This would also work =IF(A1="","",YEAR(TODAY())-YEAR(A1)) HTH Simon Jamie wrote: I need a formula that will just return age in years from a given birthdate. I have tried using =DATEDIF(A1,TODAY(),"y") but if I do not insert a birthdate then the formula returns 106 -- -------------------- Simon - UK Email at simon22mports [ a t ] hot mail [ d ot ]com Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need a formula to help me calculate years of vesting for 401K. | Excel Worksheet Functions | |||
| Convert years to years and days | Excel Discussion (Misc queries) | |||
| Data Range Mess | Charts and Charting in Excel | |||
| To create formula to add 3 years and subtract 1 day from a date? | Excel Worksheet Functions | |||
| I need the difference between two dates expressed as 4 years 3 mo. | Excel Discussion (Misc queries) | |||
Linear Mode
