[Solved] Revolving Daily Count from Previous Day

[DroneDummy]

Using the table attached, I'd like to run a recurring count that constantly displays the count of entries from each different dept from the previous day.

 

[shamimarita]

Using the table attached, I'd like to run a recurring count that constantly displays the count of entries from each different dept from the previous day.

View attachment 1513

Hello DroneDummy,

In an empty column, use the following formula to check if the date is the previous day:

=IF([@Date]=TODAY()-1, "Previous Day", "Other")

Then use the COUNTIFS function to count entries from each department for the previous day.
In a separate summary section, create labels for each department.
Use the following formula to count the entries for each department:
=COUNTIFS(Table1[Dept.], "LAM", Table1[Date], TODAY()-1)
You can replace the Dept name with the cell reference.


Apply this formula to all departments.

Download the Excel file: