WeekdayName returning wrong values

Hi guys
I'm using weekdayname and constantly getting not the name of the actual weekday but the name of the next one. At first I thought it had something to do with the date format and the macro was reading 01.09.2009 not as September 1st 2009 but as January 9th 2009, however I soon discovered this was not the case.

The same thing happens with the DatePart function

Datepart ("w", Date) should return the value 2 for today (September 1st) but it's returning 3, just like weekdayname returns Wednesday and not Tuesday.

How is this possible and what can I do (besides manually subtracting 1 from the result of the Datepart function and then using WeekdayName)

Thanks
Nick

I thought I had tried that ... but obviously I hadn't.
Thanks for the help, it worked!