Formula Returns Blank Result

megan.griffiths

Hi all,

Please can someone help. I have a formula that has worked every day up until today (Thursday). Can anyone spot what I am doing wrong?

=IF(WEEKDAY(TODAY()) = 2, COUNTIF({Date Received}, TODAY(-3)), IF(WEEKDAY(TODAY()) = 1, COUNTIF({Date Received}, TODAY(-2)), IF(WEEKDAY(TODAY()) = 7, COUNTIF({Date Received}, TODAY(-1), IF(WEEKDAY(TODAY()) = 4, COUNTIF({Date Received}, TODAY(-1), IF(WEEKDAY(TODAY()) = 3, COUNTIF({Date Received}, TODAY(-1)), IF(WEEKDAY(TODAY()) = 5, COUNTIF({Date Received}, TODAY(-1)), IF(WEEKDAY(TODAY()) = 6, COUNTIF({Date Received}, TODAY(-1)))))))))))

Thanks,

Meg

Paul Newcome

It looks like a misplaced closing parenthesis after the first and second TODAY(-1). Once you add those in, double check your ending parenthesis. You should have 7.