Countifs between dates

**Hleroux** · 03-07-2012, 07:24 AM

The diffent items I have are as follow:
-F-Phase the item falls under
-K-Phase Item must fall under
-AX-Approval Report Number
-AY-Approval Report Date

=COUNTIFS('Proj Data'!$F$9:$F$4123,'Proj Data'!$K$1,'Proj Data'!AX9:AX4123,"<>",'Proj Data'!AY9:AY4123,">="&DATE(2012,3,1))

Currently the formula only count the items after the listed date.

I need to update the formula to count the approvals between two different dates as I need to report p/quarter.

Quarter 1: 1 March - 31 May
Quarter 2: 1 June - 31 August
Quarter 3: 1 September - 31 November
Quarter 4: 1 December - 29 February

A solution to my problem or a new formula will be much appreciated!

**daddylonglegs** · 03-07-2012, 07:29 AM

You can add a new criterion for the end date, e.g. for quarter 1

=COUNTIFS('Proj Data'!$F$9:$F$4123,'Proj Data'!$K$1,'Proj Data'!AX9:AX4123,"<>",'Proj Data'!AY9:AY4123,">="&DATE(2012,3,1),'Proj Data'!AY9:AY4123,"<"&DATE(2012,6,1))

**Pepe Le Mokko** · 03-07-2012, 08:14 AM

=COUNTIFS('Proj Data'!$F$9:$F$4123,'Proj Data'!$K$1,'Proj Data'!AX9:AX4123,"<>",'Proj Data'!AY9:AY4123,">="&DATE(2012,3,1),'Proj Data'!AY9:AY4123,"<"&DATE(2012,6,1))

What does the highlighted part mean?