Hi guys,
So I have a report to run and it is must show the last 4 weeks dates (week commencing a Monday always), what I've done is get a date 01/01/2013 then done a =YEAR&WEEKNUM,2 on it to get something like 20132 so i can do quick and simple IFS. The problem however is the report needs to show the last 4 weeks with the week commencing date. So...
If i run it on 17th Jan and want to show the 4 previous weeks commencing underneath how do i do this, the answer is obviously Monday 7th Jan 2013 but don't want to type it manually? I've done a temporary fix (=17/1/2013-7days) but that isn't good enough.
Also tried to do weekday on each day in 2013 and done a (LEFT) formula to pick up everything that starts with the first day of the month but got confused, and you probably are now as well after all of that malarkey. Example below;
Remember week commencing needs to be the Monday;
Report date 16/1/13
Week Commencing
09/01/2013 - should be 7/1/13
02/01/2013 - should be 31/12/12
26/12/2012 - should be 24/12/12
19/12/2012 - should be 17/12/12
Any help will be MASSIVELY appreciated!!!!!
Bookmarks