| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
calculate date differences in years and months
How do I calculate differences in dates in months and years? I can do days,
months, and years, but not a combination. |
|
#2
|
|||
|
|||
|
Hi Joyce
something like this =DATEDIF(A1,B1,"y")&" years, "&DATEDIF(A1,B1,"ym")&" months" with your starting date in A1 and your ending date in B1 Cheers JulieD "Joyce" wrote in message ... How do I calculate differences in dates in months and years? I can do days, months, and years, but not a combination. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Where is DateDiff function in Excel 2002 ? | Excel Worksheet Functions | |||
| Converting months to years | Excel Worksheet Functions | |||
| Calculate due date 1 or 2 years ahead to the first of the followi. | New Users to Excel | |||
| Calculate months and years | Excel Discussion (Misc queries) | |||
| How do I display months and years between two dates | Excel Discussion (Misc queries) | |||
Hybrid Mode
