• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Calculate selling days per weekday and excluding holidays

naina

New Member
hello there- Hope you all are doing great

I want to calculate the # of selling days ( by week day- Mon, Tue,wed, Thurs, Fri) from a start date( including) to end date(including) .

Also, i want to exclude the holidays. examnple:
I want to calculate how many Mon,Tue, Fris' are between 5/23/2022 to 5/31/2022?
Total number
M: 2
T:2
W:1
T:1
F:1


But what I want to do is exclude the Holidays too. example: If May 30 is a holiday then I want Monday to be 1 ( and not 2).

Can anyone please help with this? i have attached my sheet with example.
Thanks a lot
Naina
 

Attachments

  • example .xlsx
    975.7 KB · Views: 3
thank you- this formula works if I need to know the total work days- unfortunately doesn't work for the #weekdays:(.
 
See cells D4:D8 in the Best Estimate Tool sheet.
Formulae are of the ilk:
=NETWORKDAYS.INTL($C$2,$D$2,"1011111",$H$2:$H$6)
for Tuesdays.
I hard coded cell C2 (removed Today()) so that it would remain correct against the What I want column.

ps. The information to do this was present in the link that @AlanSidman gave, under Bonus Tip
 

Attachments

  • Chandoo48094example .xlsx
    976.8 KB · Views: 5
Last edited:
Back
Top