Been wondering how to do this task. Say I have a date that starts from 11.Apr.2021, and I have Weekdays as a header.
Now, I want to automatically calculate the previous week based on the start date/timesheet date as per below table. So the table on weekdays would be backdated for a week. Appreciated your help on this one.