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!