End of month formula

[Peak Seagull]

Hi - As you will see from the attached spreadsheet, I am trying to add a column that will help me to calculate a rolling 12 month figure using the formula =AND(B7>=EOMONTH(TODAY(),-13)+1,B7<EOMONTH(TODAY(),-1)).

This seems to work apart from leap years and it doesn't seem to be picking up the 31/05/2020 as being part of May.

Am I being thick or can someone enlighten me in what I am doing wrong.

Thanks a lot.

 

[Chihiro]

EOMONTH will accommodate for leap year.

I think your comparison operator is off... Should it not be... something like below?
I.E. Between 6/1/2019 to 5/31/2020.
=AND(B7>EOMONTH(TODAY(),-13)+1,B7<=EOMONTH(TODAY(),-1))

Your formula checks for Between 5/31/2019 to 5/30/2020.

 

[Peak Seagull]

That's brilliant - thanks a lot for your help - I had it round the wrong way.