Networkdays and Days360

[jjdwhitfield]

All

Does anyone know how to combine networkdays and days360 so that a formula counts the number of days but excludes weekends and holidays?

Kind Regards

Jon Whitfield

 

[Sandeep Warrier]

Networkdays already excludes weekends. You can use it to exclude Holidays too. If you have 5 holidays and the dates of those holidays in cells B1:B5, then

=NETWORKDAYS(A1,A2,$B$1:$B$5)

Where A1 is your start date & A2 is end date will give you total number of working days.

 

[jjdwhitfield]

Thank you!!