View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bobm bobm is offline
external usenet poster
 
Posts: 19
Default Weekday() result differs from one computer to another ???

Hello,

Don't why I get different a result from one computer to another using the
Weekday and Weekday name functions. I am specifying Sunday as weekday 1 not
using the default and still get different results.

The code I am using is...

WeekdayName(Weekday(StartDate, vbSunday), vbSunday)

On one computer which is correct I get...

1 Sun
2 Mon
3 Tue... etc

On the other I get...
1 Mon
2 Tue
3 Wed... etc

The worksheet function works correctly on both but not VBA. Any help
appreciated.

bobm