| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ROUNDING UP monthly differences
Hey Guys,
Simple solution I found myself!!! =if(day(A1)=day(A2),datedif(a1,a2,"m"),datedif(a1, a2,"m")+1) Thanx anyway for all your help!!! "FARAZ QURESHI" wrote: Hi every1 I want to calculate the number of months between two dates. Datedif() may be used but upon a difference of less than 15 days it rounds off the balance to 0 months. I want to Round Up the difference upon a fractional month i.e. even 1 day difference returns a 1 month difference and 13 months and 1 day to be showing 14 months! All assistance shall highly be obliged! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need a formula with rounding up & rounding down to the nearest . | Excel Worksheet Functions | |||
| differences between XL VBA for the Mac and for Windows? | Excel Discussion (Misc queries) | |||
| Rolling Monthly Amounts to Annual Monthly Amounts | Excel Discussion (Misc queries) | |||
| How do I set up monthly random work schedule for 60 hours monthly | Excel Discussion (Misc queries) | |||
| Mortgage template comparing interest pd, monthly, bi-monthly, ext. | Excel Discussion (Misc queries) | |||
Hybrid Mode
