Hello, I was wondering if it was possible to remove week 53 from excel.
WEEKNUM(TODAY()-(7*11)) = 2
WEEKNUM(TODAY()-(7*12)) = 53
WEEKNUM(TODAY()-(7*13)) = 52
The database I'm using doesn't have a week 53. I'd like the 53 to be 1.
I had found a solution by converting everything with system 2 (WEEKNUM(TODAY()-(7*?),21)). The thing is, I also have a year function i.e. YEAR(TODAY()-(7*?)).
So basically, I would have XYZ-1-2013 instead of XYZ-1-2014.
Any solutions to this?
Cross post : http://www.msofficeforums.com/excel/20314-remove-week-53-excel.html#post61180
WEEKNUM(TODAY()-(7*11)) = 2
WEEKNUM(TODAY()-(7*12)) = 53
WEEKNUM(TODAY()-(7*13)) = 52
The database I'm using doesn't have a week 53. I'd like the 53 to be 1.
I had found a solution by converting everything with system 2 (WEEKNUM(TODAY()-(7*?),21)). The thing is, I also have a year function i.e. YEAR(TODAY()-(7*?)).
So basically, I would have XYZ-1-2013 instead of XYZ-1-2014.
Any solutions to this?
Cross post : http://www.msofficeforums.com/excel/20314-remove-week-53-excel.html#post61180