Question: How to determine/check if date is a weekend in Excel?
Answer: =IF(WEEKDAY(BA61,2)<6, “Workday”, “Weekend”)
PS: Change the BA61 to your column.
3/2/2020 16:57 | Workday |
3/1/2020 11:48 | Weekend |
3/3/2020 11:03 | Workday |
2/17/2020 18:28 | Workday |
Question: How to determine/check if date is a weekend in Excel?
Answer: =IF(WEEKDAY(BA61,2)<6, “Workday”, “Weekend”)
PS: Change the BA61 to your column.
3/2/2020 16:57 | Workday |
3/1/2020 11:48 | Weekend |
3/3/2020 11:03 | Workday |
2/17/2020 18:28 | Workday |