| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel formula calculating age
I'm currently using the formula =INT((TODAY()-B2/365.25) to calculate
age in years. Is there a formula that will show age in months only, if under 1 year, and age in days only, if under 1 month? I used =DATEDIF(birthdate, TODAY(),"y")&"years"&DATEDIF(birthdate, TODAY(),"ym")&"months"&DATEDIF(birthdate, TODAY(),"md")&"days" but I only want years or months or days to show. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula for calculating wt gain or loss cumulative in excel | Setting up and Configuration of Excel | |||
| Entering a Formula; Remains a Formula Instead of Calculating | Excel Discussion (Misc queries) | |||
| How keep Excel from counting empty cells when calculating formula | Excel Worksheet Functions | |||
| Excel displaying formulae as constant and not calculating formula | Excel Worksheet Functions | |||
| Formula for calculating a rolling 12 month average in excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
