WeekNumber & WeekDay error
Can anyone help with a way round the weeknum formula that starts on a Monday rather than a Sunday?
I'm using the WeekNumber formula to get a current week in conjunction with the WeekDay formula to create a list of tasks due in a current week sorted by days. Because the dates for when each task is due is auto populated based on a delivery date, sometimes the tasks end up being assigned to a Saturday or Sunday.
For example a task due on Sunday 29/05/22 is showing as a Current week task and is assigned to week day 1. Therefore it's showing in the task list for Monday 23/05/22.
Any suggestions please?
Help Article Resources
Check out the Formula Handbook template!