View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default weekday function in excel 2007 wrong

for 1900-01-01 to 1900-02-28 there is returned a wrong weekday. reason:
1900
is considered as a "leap year", but it is definitely not.


It's a known bug...

http://support.microsoft.com/kb/214326

Rick