tmd63
New Member
- Joined
- Feb 21, 2014
- Messages
- 40
- Office Version
- 2013
- 2003 or older
- Platform
- Windows
I am trying to use the WEEKNUM function but it miss reports the week.
example cell function in B7 =WEEKNUM(B6,11)
using a date of 29/12/15 reports week 53 (Week 53 is December 28th 2015 to January 3rd 2016)
but put a date of 01/01/2016 reports week 1?? It is still part of week 53.
https://www.epochconverter.com/weeks/2015
Why is this function miss reporting the week numbers as Jan 4th 2015 is week 1 and NOT week 2.
The same happens in 2016 and 2017.
example cell function in B7 =WEEKNUM(B6,11)
using a date of 29/12/15 reports week 53 (Week 53 is December 28th 2015 to January 3rd 2016)
but put a date of 01/01/2016 reports week 1?? It is still part of week 53.
https://www.epochconverter.com/weeks/2015
Why is this function miss reporting the week numbers as Jan 4th 2015 is week 1 and NOT week 2.
The same happens in 2016 and 2017.
Last edited: