Scribd
Upload
54 views2 pages

Holiday Date Calculation Examples

The document provides examples of calculating workdays between specified start and end dates while excluding holidays. It includes two sets of examples with corresponding results for each calculation. The calculations utilize the NETWORKDAYS function to account for weekends and holidays in the workday count.

Uploaded by

shobha m
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
54 views2 pages

Holiday Date Calculation Examples

The document provides examples of calculating workdays between specified start and end dates while excluding holidays. It includes two sets of examples with corresponding results for each calculation. The calculations utilize the NETWORKDAYS function to account for weekends and holidays in the workday count.

Uploaded by

shobha m
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Example 1:

Start date End date


Dec 11,2016 Dec 31,2016
Dec 11,2016 Jan 10,2017
Mar 20,2014 Mar 29,2014
Mar 27,2014 Apr 5,2014

Holiday Name Holiday Dates


Good Friday Mar 25,2014
Christmas Dec 25,2016
New Year Day Jan 1,2017
Easter Monday Mar 28,2014

Start date End date Holiday Dates Result


December 11, 2016 December 31, 2016 March 25, 2014 15
December 11, 2016 January 10, 2017 December 25, 2016 22
March 20, 2014 March 29, 2014 January 1, 2017 5
March 27, 2014 April 5, 2014 March 28, 2014 6

Example 2:

Start date End date Holidays Formula Result


=NETWORKDAYS(A26,B
January 1, 2017 December 31, 2017 December 26, 2017 26) 260
=NETWORKDAYS(A27,B
January 1, 2017 December 31, 2017 December 25, 2017 27,$C$26:$C$27) 258

=NETWORKDAYS(A28,B
December 20, 2017 December 31, 2017 28) 8

=NETWORKDAYS(A29,B
December 20, 2017 December 31, 2017 29,$C$26:$C$27) 6
Explanation
Only weekends
excluded
Weekends+Holidays
excluded

Only weekends
excluded

Weekends+Holidays
excluded

You might also like