Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to determine the number of months between 2 periods?
Eric,
Isn't it simply =DATEDIF(A1,B1,"m") with A1 as the earlier date Mike "Eric" wrote: Does anyone have any suggestions on how to determine the number of months between 2 periods? such as 01 May, 2006 and 01 Jun, 2007, there is 13 months between 2 periods, The default day for each period is 1 of each month. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to determine the number of months between 2 periods? | Excel Discussion (Misc queries) | |||
How to determine the number of months between 2 periods? | Excel Discussion (Misc queries) | |||
How to determine the number of month between 2 periods? | Excel Discussion (Misc queries) | |||
How to determine the number of month between 2 periods? | Excel Worksheet Functions | |||
How to determine the number of workday between two periods? | Excel Discussion (Misc queries) |