Where does the reference (weekends/holidays)

Solved/Closed
sillyme - Dec 17, 2009 at 08:31 AM
 sillyme - Dec 20, 2009 at 10:20 AM
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 May 23, 2009 Status Contributor Last seen October 20, 2010 183
Dec 18, 2009 at 06:00 PM
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.
0
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
0