Good Day,
I’m having some trouble working this one out and come seeking help again! What did people do before the internet! 
I have a spread sheet with a number of job tasks that need to be completed when due, once completed we then reschedule the task for a set number of days.
What I’m trying to do is if I close the task any day after Monday, I would like the future date to always revert to the closest Monday automatically when I press refresh.
I have attached a sample workbook where we add the date, then add a frequency (number of days) then press refresh date, this will give me both the date and week number.
Hope I’ve explained well enough, any help will be appreciated.
Many thanks,
Ryan
