Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count the number of months between 2 periods?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count the number of months between 2 periods?
In C1: =DATEDIF(B1,A1,"m")
-- Max Singapore http://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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 - |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to count the number of months between 2 periods?
It's important to lots of things in life. People get paid monthly, pay their
rent monthly, car leases, mortgage payments, etc. It's not their fault that months are different lengths. They still want to know the number of months. Regards, Fred. "Pete_UK" wrote in message ... 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 - |
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 months between 2 periods? | Excel Discussion (Misc queries) | |||
How to determine the number of months between 2 periods? | Excel Discussion (Misc queries) | |||
formula to count number of months that have passed | Excel Discussion (Misc queries) |