marcvanderpeet12
Member
Guys,
Im using the WEEKNUM function to transfer a date to a weeknum.
In cell A2 I have a data ("29-12-2007") but when I enter =WEEKNUM(A2, 1) in in B2 i get "22-02-1900" instead of the weeknumber. A
Any thoughts what goes wrong here?
Im using the WEEKNUM function to transfer a date to a weeknum.
In cell A2 I have a data ("29-12-2007") but when I enter =WEEKNUM(A2, 1) in in B2 i get "22-02-1900" instead of the weeknumber. A
Any thoughts what goes wrong here?