workday(TODAY(),0,0) and IF statement issues

[Enzo_Matrix]

I am tracking our shipping departments shipments and have a basic table with 5 columns of data and am trying to automate the data collection from the report generated by our system.

Date	Total Orders	Total Late	% Late	% On-time
1-Jan-2019	9	1	11.11%	88.89%
2-Jan-2019	11	0	0.00%	100.00%

<tbody>
</tbody>

I have a cell that changes dates from day to day and the idea is that it will automatically import the information into column 2 and 3 based on yesterdays date.

Cell that changes dates    =WORKDAY(TODAY(),-1,1)

Total Orders calculation from raw data   =IF('Table Date'=Cell with changing date,Total Orders,"")
Total Late calculation from raw data     =IF('Table Date'=Cell with changing date,Total Late,"")

In each cell of column 2 and 3 I have a code the references the date cell and the cells in my data sheet(see IF statements above). My issue is that as the date changes, the cells from my table clear themselves and i'm not sure which code would work better.

Any suggestions would be great! Also, VBA is an option