ExcelBanter - When I convert a date to a weekday, Sunday becomes Thursday?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - When I convert a date to a weekday, Sunday becomes Thursday? (https://www.excelbanter.com/excel-worksheet-functions/86634-when-i-convert-date-weekday-sunday-becomes-thursday.html)

FredYorkII

When I convert a date to a weekday, Sunday becomes Thursday?

I am working with an Excel 2003 spreadsheet that has several date columns ,
mm/dd/yy which I need to add a column and convert to the correct day of the
week. Every time I try to do this I get Thursday for Sunday, why?

Ron Coderre

When I convert a date to a weekday, Sunday becomes Thursday?

Please post your formula so we can see what method you're currently trying.

***********
Regards,
Ron

XL2002, WinXP-Pro

"FredYorkII" wrote:

I am working with an Excel 2003 spreadsheet that has several date columns ,
mm/dd/yy which I need to add a column and convert to the correct day of the
week. Every time I try to do this I get Thursday for Sunday, why?

All times are GMT +1. The time now is 03:13 AM.