Yesterday's Completed Task Formula

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!

Find more posts tagged with

Formulas

Comments

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))