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.mrexcel.com/forum/excel-q...ml#post3758264