Count days between two dates

Calculate the days of work between two dates with the NETWORKDAYS function

Start Date: 15/5/2020

End Date: 28/1/2021

Holiday 1: 26/8/2020

Holiday 2: 18/11/2020

Holiday 3: 15/1/2021

Calculate the days between two dates with the NETWORKDAYS function excluding

Holiday 1, Holiday 2 and Holiday 3. Saturday and Sunday are omitted.

Result

Number of days between the two dates: 182

#softexperia #excel_tips