Issue with TEXT Function and Displaying Day of the Week (Zoho Sheets)

Issue with TEXT Function and Displaying Day of the Week (Zoho Sheets)

Hello,

I'm using the formula =TEXT(DAY(A1);"DDDD") in Zoho Sheets to display the full day of the week for a date in cell A1. However, when I enter a date like 2/7/2024 (MM/DD/YYYY), the formula doesn't return the correct day (Wednesday in this case).

Can anyone help explain why this might be happening and suggest a solution?

Thanks.