My current formula is this:
=COUNTIF($A$5:$A$336,TODAY()-1) - where column A has dates (Monday thru Saturday dates entered Monday through Friday).
But if yesterday was a Sunday, my formula is this:
=COUNTIF($A$5:$A$336,TODAY()-2)+COUNTIF($A$5:$A$336,TODAY()-3)
I have to pass this spreadsheet on to someone with very little formula (or excel) knowledge. Explaining how to change the formulas every Monday and change it back on Tuesday is not an option. What is a more permanant solution?
Thank you in advance,
Ambrosia
Bookmarks