Yesterday's Completed Task Formula

Marie Eastman

I am looking for a way to capture the number of taks that were completed yesterday. I started by using a report however yesterday or last working day were not an option. I tried using in the last days - and used 1 however when yesterday is a weekend is skews the data. I then tried using a COUNTIFS formula but I run into the same issue when yesterday is a Sunday.

=COUNTIFS([RHB TO AUDITOR]:[RHB TO AUDITOR], (TODAY() - 1)) 

When I try adding NETWORKDAY I get an error. what is wrong with my formula?

=COUNTIFS([RHB TO AUDITOR]:[RHB TO AUDITOR], NETWORKDAYS(TODAY() - 1))

I want to count if that field was yesterday.

 

Thanks for the help!

Kara Lumley

Hi Marie,

What do you want to happen if yesterday was a weekend - go back to the previous Friday? Let me know and I'll work on it!

Marie Eastman

Yes. Thats why I was thinking NETWORKDAY - let me know! thanks.

Kara Lumley

This is a start - this will count everything that was completed yesterday and not a weekend:

 

=COUNTIF([RHB TO AUDITOR]:[RHB TO AUDITOR], @cell = (TODAY() - 1)) - COUNTIFS([RHB TO AUDITOR]:[RHB TO AUDITOR], OR(IFERROR(WEEKDAY(@cell), 0) = 1, IFERROR(WEEKDAY(@cell), 0) = 7), [RHB TO AUDITOR]:[RHB TO AUDITOR], @cell = (TODAY() - 1))