View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default How to count the number of months between 2 periods?

Why do people insist on counting months ?

Pete

On Feb 5, 1:52*pm, Max wrote:
In C1: =DATEDIF(B1,A1,"m")
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik
---



"Eric" wrote:
Does anyone have any suggestions on how to count the number of months between
2 periods? such as
Assuming the the day for each period is 1 as a default.
In cell A1, the period is 1-Mar-08 and
In cell B1, the period is 1-Feb-08,
then it should return 1 in cell C1, because there is 1 month between 2
periods.
Does anyone have any suggestions?
Thanks in advance for any suggestions
Eric- Hide quoted text -


- Show quoted text -