The workday formula calculates the number of working days in the past or future.
You can calculate due dates in Excel using the workday function. For example, if the start date is 5-Jan-2020 and is under cell B4, the total days are 100, and in cell C4. We calculate the due date using the following formula =WORKDAY(B4, C4)
You use the DATEDIF() function, which has the following syntax =DATEDIF(Start_Date, End_Date, Metric). The metric can be days, years, or months.
The formula we use to calculate days between two dates is simple subtraction. You subtract the dates from each other.