Easy Date Incrementation in a formula

Simply put your dates in Cells;

=COUNTIFS('National Working Fleet'!$E:$E,">=" & X1,'National Working Fleet'!$E:$E,"<=" & X2,'National Working Fleet'!$F:$F,"",'National Working Fleet'!$G:$G,"On-Circuit").

X1 and X2 contain your dates

Thanks for that.

But that will not work as I get the data from another report that has the dates in 2 columns, as per the attached image.

Is there any other way to do this

Thanks

Post a small sample file showing expected results.

Hi John,I have attached the sample sheet as you have asked.

I am grateful to you for you looking at this. It has got me confused.

Kind Regards

It's not as easy as just incrimenting the month, because you also have to consider the DAY in the Ending Date
31/05/2015 would need to cnange to 30/06/2015 (both Month AND Day changed)

To accomodate that, I suggest making the End date the 1st of the Next month, and use < instead of <=
=COUNTIFS('National Working Fleet'!$E:$E,">=01/06/2014",'National Working Fleet'!$E:$E,"<01/06/2015",'National Working Fleet'!$F:$F,"",'National Working Fleet'!$G:$G,"On-Circuit").

Now you only have to incriment the month.
Try

=COUNTIFS('National Working Fleet'!$E:$E,">="&DATE(2014,6+ROWS(A$1:A1)-1,1),'National Working Fleet'!$E:$E,"<"&DATE(2015,6+ROWS(A$1:A1)-1,1),'National Working Fleet'!$F:$F,"",'National Working Fleet'!$G:$G,"On-Circuit").

Many thanks guys, that has worked a treat.

Kind Regard

Martin