Formula for calculating number of days between start and end date excluding weekends and holidays

[kmmoon100]

Hi there,

I am trying to create a formula that calculates 'days of work' within weekdays except for weekends and holidays. I acknowledge that there is 'Workday' function but it requires days of work. For example, if you have Start date: 2017-03-29 and End date: 2017-04-04 with a holiday at 2017-04-03 and weekends, what formula would make it work to calculate 'days of work' automatically?

Thanks in advance.

 

[Tetra201]

Try using =NETWORKDAYS(start_date,end_date,holidays)

 

[kmmoon100]

Try using =NETWORKDAYS(start_date,end_date,holidays)

Thank you so much! It saved a lot of time!

Have a great day!

 

[Tetra201]

You are welcome.