Bug in WEEKDAY() Formula

To be compatible with Google Sheets and Excel …

=WEEKDAY(DATE(2020,4,26),1) should return 1, not 7
When using 1 for the [type] argument, Sunday = 1

I use WEEKDAY in a lot of my spreadsheets, so this would cause a lot of problems.

Underlying fix for the defect #001569 which we are tracking will resolve this as well

This issue has been fixed as of our February 27, 2021 update.

1 Like