![]() |
#1
|
|||
|
|||
![]()
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 |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
thedeadzeds | Excel | 3 | 11-16-2013 02:06 AM |
![]() |
jyfuller | Excel Programming | 3 | 02-27-2013 10:32 PM |
![]() |
sanlen | Project | 1 | 06-25-2012 04:17 PM |
![]() |
mrgy05 | Excel | 2 | 06-07-2012 10:38 AM |
MS Excel Remove password encryption | Rio Pauline | Excel | 1 | 05-29-2012 03:34 AM |