In column C I'm using the function =weeknum(b:1,2) where b:1 is the date. I want the week to start on Monday so I put the "2" in the parentheses.
Works just fine until I get to 12/25/06. Then I find the value "53" in the column! Why am I getting an extra week in my year (not that I couldn't use it to go shopping before Christmas).
Any suggestions greatly appreciated.
Thanks!
Works just fine until I get to 12/25/06. Then I find the value "53" in the column! Why am I getting an extra week in my year (not that I couldn't use it to go shopping before Christmas).
Any suggestions greatly appreciated.
Thanks!