| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using DATEDIF how do I add another month of each date fall on same
I am using the following
=DATEDIF(C6,C5,"m") If I enter the exact same dates the answer is obviously 0, but I want it to be 1. I only want to add 1 if the dates are exactly the same. In case it helps I am trying to figure out how far behind an account is, and if the dates are the same a payment was not made and one more payment would be due. Any help would be great! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rounding a month upwards , after using an =datedif fomula | Excel Discussion (Misc queries) | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| Month (datedif) to 1 decimal | Excel Worksheet Functions | |||
| Datedif incorrect month count - February problem?? | Excel Worksheet Functions | |||
| DATEDIF calculates a month off | New Users to Excel | |||
Threaded Mode
