| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate and display year and month
E.g. when Date1 - Date2 = 850 days (=2.33 years), is there a way to display
"2 years 4 months" within one cell? I have figured out the way to display in 2 separate cells. Thanks Ken |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate and display year and month
=DATEDIF(A1,A2,"y")&" years "&DATEDIF(A1,A2,"ym")&" months
"&DATEDIF(A1,A2,"md")&" days" "kenlo" wrote: E.g. when Date1 - Date2 = 850 days (=2.33 years), is there a way to display "2 years 4 months" within one cell? I have figured out the way to display in 2 separate cells. Thanks Ken |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate year and month | Excel Discussion (Misc queries) | |||
| Calculate month & year in between two dates | Excel Worksheet Functions | |||
| Calculate month & year in between two dates | Excel Worksheet Functions | |||
| Display number of day of month depending on the year | Excel Discussion (Misc queries) | |||
| how to calculate total months from month/year | Excel Discussion (Misc queries) | |||
Linear Mode
