Count Month

[NavinReddy]

Hi All,

I want to count all previous three year months

01-03-2011 from to till date how many months please help me

Thanks in Advance

Niranjan

[MK_QSL]

Dear Niru

You can try below....

=IF(Num(Month(Max(Date)))-Num(Month(Min(Date)))>=0,

  ((Num(Year(Max(Date)))-Num(Year(Min(Date))))*12)+Num(Month(Max(Date)))-Num(Month(Min(Date)))+1,

  (NUM(Year(Max(Date))-Num(Year(Min(Date)))-1)*12)+13-Num(Month(Min(Date)))+Num(Month(Max(Date))))

[tresesco]

Goto variable overview and change the definition of vStartNum : like :

[Anonymous]

Niru,

Here is the formulae you can use to get the months.

(Year(Today(2))*12 + Month(Today(2))) - (Year(Date#('01-03-2011','DD-MM-YYYY'))*12 + Month(Date#('01-03-2011','DD-MM-YYYY')))