LinkBack URL
About LinkBacks
Hi all,
When I am trying to run my WEEKNUM function it is giving me a value of 1/9/1900. My data is formatted as a date in A1 and running this in B1 gives me the date. Any help or ideas as to why?
Thank you,
Hi all,
When I am trying to run my WEEKNUM function it is giving me a value of 1/9/1900. My data is formatted as a date in A1 and running this in B1 gives me the date. Any help or ideas as to why?
Thank you,
Hello jacksilvert
Sounds like a formatting issue - reformat cell B1 (the cell with the formula) as number or general - 1/9/1900 is how Excel shows the number 9 when formatted as a date
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks