Return True or False if date range falls within current month

[kieran614]

I have a simple spreadsheet that has column A as a "From Date" and column B as a "To Date".


From Date To Date
03/28/2013 04/04/13
04/04/2013 04/11/13
04/11/2013 04/18/13
04/18/2013 04/25/13
04/25/2013 05/02/13
05/02/2013 05/09/13

In column C, I want to have a formula that returns a true or false if the range falls within the current month.

Please help.

[FDibbins]

Hi and welcome to the forum

Try this in C2, copied down...

=AND(MONTH(A2)>=MONTH(TODAY()),MONTH(B2)<=MONTH(TODAY()))