Leave blank if date is in the future

Alywilk

I'm wanting a cell to be blank if the month is in the future (highlighted cells below) but once we are in that current month to start counting. Right now my formula is pulling from our master page and counting all the entries with in a certain time period but not sure where to go from there.

=COUNTIFS({Created}, <=DATE(2022, 3, 31), {Created}, >=DATE(2022, 3, 1))

Genevieve P.

Hi @Alywilk

You can add an IF statement at the beginning that says IF Today's Date is less than DATE(2022, 3, 1), return blank: ""

Try this:

=IF(TODAY() < DATE(2022, 03, 01), "", COUNTIFS({Created}, <=DATE(2022, 03, 31), {Created}, >=DATE(2022, 03, 01)))

Cheers!

Genevieve

Genevieve P.

Hi @Alywilk

You can add an IF statement at the beginning that says IF Today's Date is less than DATE(2022, 3, 1), return blank: ""

Try this:

=IF(TODAY() < DATE(2022, 03, 01), "", COUNTIFS({Created}, <=DATE(2022, 03, 31), {Created}, >=DATE(2022, 03, 01)))

Cheers!

Genevieve

Alywilk

Thank you that worked!