How many Quarter between 2 dates?

[RENU1973]

I want to know an excel formula to calculate the how many quarter falls between 2 dates?

Suppose,one date is 22/05/2013 and other date is 05/02/2014.Then the total quarter should be 4.

Quarter criteria should be:-
Jan~Mar
Apr~Jun
Jul~Sep
Oct~Dec

Date fall in the above range should count 1 Quarter.22/05/2013 falls in 'Apr~Jun' and 05/02/2014 falls in 'Jan~Mar,then,total Quarter are 4.

Can it be calculate through an excel formula?'

[Rudi]

Attached...

Book1.xlsx

[Rudi]

As for your other question about VBA form, see if this works for you.

Age Calculator.xlsm

[StuartR]

Rudi,

Thanks for answering both questions in this thread. I was trying to decide whether to unlock the other one again when you resolved the issue anyway!

[RENU1973]

Rudi Sir,in excel file attach by you,the formula is showing 2 quarter instead of 3 as I want.Have a look into the formula once again.

But Rudi sir,look into VBA Codes file ,in this file one date is 22/05/2013 and other is 05/02/2014 and the quarter should be 4 instead of 3 as per your solution.Request you to please look once again.The criteria should be Jan~Mar,Apr~Jun,Jul~Sep and Oct~Dec.Date first is falling into Apr~Jun and other date i.e.05/02/2014 is falling into Jan~Mar.Therefore,it should be 4.

Regards
Renu

[HansV]

Does this do what you want?

Age Calculator.xlsm

[RENU1973]

Yes Hans that is the solution which I want.Thanks a lot for your effort.

Sir,request you to please suggest/amend an excel formula as attach by Mr.Rudi,that is not my requirement.

[RENU1973]

Hans Sir,sorry for the not looking proper text.Please correct the last text in your attach file of macro as 'Quarter'instead of 'Total Days'.

[HansV]

In D5:

=DATEDIF(DATE(YEAR(B5), MONTH(B5)-MOD(MONTH(B5)-1,3),1),DATE(YEAR(C5), MONTH(C5)-MOD(MONTH(C5)-1,3),1),"m")/3+1

Excel may format the result as a date. Simply set the number format to General.
Fill down the formula as far as needed.

[HansV]

Hans Sir,sorry for the not looking proper text.Please correct the last text in your attach file of macro as 'Quarter'instead of 'Total Days'.

You can change the Caption property of the label yourself.

[RENU1973]

Thank you Hans for both the reply.Now Glad to find the right solution.

Many-2 thanks to you once again.

Regards
Renu