ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to determine the number of months between 2 periods? (https://www.excelbanter.com/excel-discussion-misc-queries/154459-re-how-determine-number-months-between-2-periods.html)

Mike H

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