calculate quarters between two dates

[hkbhansali]

Hi,
I need to calculate how many quarters betwen two dates

I have "26-may-2015" in call "A1" & "31-mar-2016" in cell "B1"

Thanks.

[Teethless mama]

=INT(DATEDIF(A1,B1,"ym")/3)

[AlKey]

Try this

Please Login or Register  to view this content.

this one should work too

Please Login or Register  to view this content.

[Phuocam]

Hi,
I need to calculate how many quarters betwen two dates

I have "26-may-2015" in call "A1" & "31-mar-2016" in cell "B1"

Thanks.

A1=1/1/2016 , B1 =31/3/2016 -> result?
A2 =31/3/2016, B2 = 1/4/2016 -> result?

[hkbhansali]

Thanks teethless mama

its work....

[hkbhansali]

Hi Alkey

both formula works fine..

Thanks

[Teethless mama]

You're Welcome!