Quarter between two dates ?

**RAKESH230583** · 10-11-2009, 04:28 AM

HELLO ,

I want one or two formula IN EXCEL by which I can calculate.

1. No of years , No of Months , No of weeks - Between two given dates

2. No of complete quarters - Between two given dates

Eg: Start Date = 01 jan 2009 and End date is 31 march 2009 = it should give me a result as 01 Quarter

But, if end date goes to 01 April 2009 = It should give me a result as 01 Quarter and 01 Day.

Request you to kindly help me ASAP

Rakesh230583

**JBeaucaire** · 10-11-2009, 04:41 AM

Assuming the two dates are in A1 and B1:

1) Use the DATEDIF() function
Years =DATEDIF(A1,B1,"y")
Months =DATEDIF(A1,B1,"m")
Weeks =INT(DATEDIF(A1,B1,"d")/7) + 1

2) Quarters
=INT((DATEDIF(A1,B1,"m")+1)/3)

But that gives you the quarters dif only. This particular category would really require you give about 3-4 different examples with sample results, maybe more.

1/1/2009 - 3/31/2009
3/1/2009 - 4/1/2009
2/1/2009 - 8/15/2009
3/29/2009 - 11/13/2009
...etc.

**RAKESH230583** · 10-11-2009, 05:02 AM

as per the Quarter formula which you gave to me is =INT((DATEDIF(A1,B1,"m")+1)/3)

But, in this case if,
Start date is 01 January 2009 and End Date is 31 March 2009 its gives me 1 Quarter,

while if End date goes to 30 June 2009 it gives me 01 Quarter only..

Is it possible that I can get a result as 01 Quarter and No of days after completing 01 Quarter till End Date. i.e 30 june 2009

**RAKESH230583** · 10-11-2009, 06:07 AM

its very urgent..
Can any one please help me..
please please

**DonkeyOte** · 10-11-2009, 06:11 AM

Does the start date always coincide with the beginning of a Quarter ?

As JB has already stated - provide more example dates & expected results which cover all variants of your requirements, this way people will be able to ensure they capturing your requirements.