| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Expanding Date formula
Hi I use this formula to calculate how many months and days between two dates : =DATEDIF(C4,C6,"YM") & " Months, " & DATEDIF(C4,C6,"MD") & " Days" However , it doesn't work when there is more than a year between the two dates. Can someone advice how to modify the formula so it incorporates the extra multiples of 12 months if they are present? I only need to return months and days. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Expanding Date formula
On Tue, 11 Feb 2014 22:51:11 +0000, Colin Hayes wrote:
Hi I use this formula to calculate how many months and days between two dates : =DATEDIF(C4,C6,"YM") & " Months, " & DATEDIF(C4,C6,"MD") & " Days" However , it doesn't work when there is more than a year between the two dates. Can someone advice how to modify the formula so it incorporates the extra multiples of 12 months if they are present? I only need to return months and days. Thanks cpearson.com has information regarding the datedif function. Try changing "ym" to just "m" |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Expanding Date formula
cpearson.com has information regarding the datedif function. Try changing "ym" to just "m" Hi OK thanks for this. It's working fine now. Grateful for your help. Best Wishes , |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| expanding a formula | Excel Discussion (Misc queries) | |||
| Expanding on a formula | Excel Worksheet Functions | |||
| Expanding Formula Bar | Excel Discussion (Misc queries) | |||
| expanding a start date and end date to show all the dates in a list | Excel Programming | |||
| Help With Expanding A Formula | Excel Worksheet Functions | |||
Linear Mode
