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 |
很久以前从朋友那里获得的,是个非常不错的计算年龄的Excel表格。能准确地计算出很多数据,可以看下图。下载Excel表格。