Excel: How to determine/check if date is a weekend in Excel?

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:57Workday
3/1/2020 11:48Weekend
3/3/2020 11:03Workday
2/17/2020 18:28Workday

Leave a Reply

Your email address will not be published. Required fields are marked *