Hi All
Can anyone help with the following please?
I would like to be able to enter any week commencing date (starting on a Monday) and be able to find where that week falls within the pattern. The pattern runs for 10 weeks and then reverts back to week one and continues for another 10 weeks and so on. Ideally I want to avoid using vlookup so I do not need to keep a long look up table or have to update the dates on the pattern every 10 weeks. Is this possible?
Thanks
Bookmarks