Hi All,
Ive spent two years developing a CRM system and now the last thing i need to do is the dating system. sales and performance etc are all filtered by year and week.
The calendar used by my place of work is a 4-4-5 calendar, so 4 weeks, 4 weeks, then 5 weeks per quarter.
The year starts on the first week, beginning with a Sunday in February. So last years week 1 was 31st Jan 2016. This years week 1 is 29th January.
I only need this to work for the next 4 years, So I can work out the date values in Excel for each of the years, and make excel translate dates that fall into those values into a year, but how can I do the same for weeks?
There are a few threads that already attack this problem, but nothing seems to solve it adequately.
thank you in advance
Bookmarks