| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
DATEDIF calculates a month off
Suppose my start and end dates are in A1 & A2 respectively and I want
to count the number of months between them A1: 09/01/04 A2: 01/31/05 =DATEDIF(A1,A2,"M") returns 4, instead of the correct count of 5. What's up with that? Anybody? Thanks. M&M |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add one month to the previuos month | Excel Discussion (Misc queries) | |||
| Month Year Date Format | Excel Worksheet Functions | |||
| Accounting Month vs. Calendar Month | Excel Worksheet Functions | |||
| UserForm to select current month or earlier | Excel Discussion (Misc queries) | |||
| How to extract month number from month name | Excel Discussion (Misc queries) | |||
Threaded Mode
