Hi all,

So I understand that the following will return 12/31 of the current year: =DATE(YEAR(TODAY()), 12, 31)

Can that be tweaked to highlight cells that remain blank after a quarter has passed (e.g., after March 31st of the current year?). The reason I'm doing current year is because this is a rolling spreadsheet that should automatically update each year.

I was thinking:

=AND($K5>=(YEAR(TODAY()),3,31),$K5="")

But I get an error message that seems to mean that my formula syntax is wrong (I'm sure it is!).



Any ideas? Thank you so much I love you guys!