| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date calculation
Hi,
I am trying to arrive at a date difference between 2 cells that will display like 9 years, 10 months, 25 days. Does anyone have a suggestion? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date calculation
Yes, here's one. With the earlier date in A1 and the later date in B1, try:-
=DATEDIF(A1,A2,"y") & " Years, " & DATEDIF(A1,A2,"ym") & " Months, " & DATEDIF(A1,A2,"md") & " Days" Mike "KarenM" wrote: Hi, I am trying to arrive at a date difference between 2 cells that will display like 9 years, 10 months, 25 days. Does anyone have a suggestion? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date calculation
Thanks so much Mike, that's just what I needed. I was kinda on that track,
but it would have taken me much longer. You saved me a lot of time. Karen "Mike H" wrote: Yes, here's one. With the earlier date in A1 and the later date in B1, try:- =DATEDIF(A1,A2,"y") & " Years, " & DATEDIF(A1,A2,"ym") & " Months, " & DATEDIF(A1,A2,"md") & " Days" Mike "KarenM" wrote: Hi, I am trying to arrive at a date difference between 2 cells that will display like 9 years, 10 months, 25 days. Does anyone have a suggestion? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A specific date used for calculation of a new date | Excel Discussion (Misc queries) | |||
| Date Calculation (from entered date / 1yr later in next field) | Excel Worksheet Functions | |||
| End Date Calculation (adding a start date duration) | Excel Discussion (Misc queries) | |||
| Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
| Coding to show first _weekday_ prior to a date, when date calculation happens to fall on weekend? | Excel Programming | |||
Hybrid Mode
