Display Date is workday in Excel
This tutorial show how to Display Date is workday in Excel using the example below. To determine if a date is a workday or not, you can use a formula based on the WORKDAY function. =WORKDAY(date-1,1,holidays)=date Explanation of how this formula works In the example shown, the formula in C5 is: =WORKDAY(B5-1,1,holidays)=B5 which returns TRUE, since Monday, …