For example DATE20161-15 returns the serial number representing December 16 2015. Number of workdays that you want to subtract from a date. NETWORKDAYSstart_date end_date holidays Unlike the WORKDAY function the NETWORKDAYS function does include or count the start day.
It then adds 1 year from cell B2 resulting in 2020.
30 days from date. Number of workdays that you want to subtract from a date. WORKDAY B5-7F5F12 WORKDAY B8-C5F8F15 GENERIC FORMULA. With the target date in B3 and the number of days in B4 the formula is as simple as adding up two cells.