Sorry - forgot to include that I need a row to show yesterday's totals too!
Ooops!
I have a table with some already completed and working formulas - need an extra three cells calculated.
Basically the table records hours worked at two sites
Then looks up today's values, and year to date.
Needs a formula to calculate and show last weeks totals too
The week for reporting purposes is Thursday till the following Wednesday
Bookmarks