Find This Month

Tim Dollmeyer

I'm trying to add a formula that will tell me if a date in a cell is this month. If a date is present in the reference cell, I get an INVALID OPERATION error. What am I missing?

=IF([Date Completed]@row = MONTH(TODAY()), 1)

Thanks!

Heather Duff

Hi @Tim Dollmeyer ,

Try this:

=IF(MONTH([Date Completed]@row) = MONTH(TODAY()), 1)

Be sure your Date Completed column is set as a date column in the column properties.

Let me know if it works!

Best,

Heather

Heather Duff

Hi @Tim Dollmeyer ,

Try this:

=IF(MONTH([Date Completed]@row) = MONTH(TODAY()), 1)

Be sure your Date Completed column is set as a date column in the column properties.

Let me know if it works!

Best,

Heather

Tim Dollmeyer

Yes it worked! It doesn't like blank cells, so I'll add a statement to ignore them.

Thanks Heather!