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 |
All times are GMT +1. The time now is 01:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com