Where does the reference (weekends/holidays)

[Solved/Closed]
Report
-
 sillyme -
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 replies

Posts
1021
Registration date
Saturday May 23, 2009
Status
Contributor
Last seen
October 20, 2010
182
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