| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
rounding a month upwards , after using an =datedif fomula
I use formula to calculate numbe rof elapsed months between 2 dates..
=datedif(a1,b1,"m").... but then want to round up to 1 month, in case the time elapsed is actually less than 1 month within the =dated calcs. Anyhelp please? Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fomula for number of days on each month from a date range | Excel Discussion (Misc queries) | |||
| Month (datedif) to 1 decimal | Excel Worksheet Functions | |||
| Datedif incorrect month count - February problem?? | Excel Worksheet Functions | |||
| rounding the DATEDIF function | Excel Discussion (Misc queries) | |||
| DATEDIF calculates a month off | New Users to Excel | |||
Threaded Mode
