Where does the reference (weekends/holidays)

Solved/Closed
sillyme - 17 Dec 2009 à 08:31
 sillyme - 20 Dec 2009 à 10:20
Hello,
in regard to your formula in counting days. you said that a list of holidays/weekends should be created. onces it is created where does that information reside. supposebly I will need that list of holidays/weekends to refer to.
thank you

2 responses

sharpman Posts 1021 Registration date Saturday 23 May 2009 Status Contributor Last seen 20 October 2010 183
18 Dec 2009 à 18:00
please could you refer to your original post.

From what I can gather about your query is where the list of holidays go in the formula.

I think you are looking for this

https://www.lifewire.com/count-days-between-two-dates-excel-3123745

it will explain about using networkdays in a formula to count days between 2 dates excluding weekends and holidays.
Thank you kindly for your reply. I have found some information on "Networkdays" after I posted the query. I would like to thank you guys, I think you are great about providing answers to anyone from ~don't know a whole lot" - "expert users". thank you so much