Greetings!
Looking for a formula that will count the number of unique dates within a designated range that will also exclude designated holidays from the unique count.
The attached might better paint the picture. (Hopefully)
Thanks!!
Greetings!
Looking for a formula that will count the number of unique dates within a designated range that will also exclude designated holidays from the unique count.
The attached might better paint the picture. (Hopefully)
Thanks!!
Hi,
an attempt
=SUMPRODUCT(((COUNTIF(B11:B13,A11:A25)=0)*(WEEKDAY(A11:A25,11)<6))/COUNTIF(A11:A25,A11:A25))
I think B12:B13 should house two different dates: maybe a typo.
Hope it could work.
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
Perfect!
Your note about the typo was correct. It should have been 01/01/2016. Changing it from 01/01/2017 to 01/01/2016 produced the correct answer, 2.
Thanks. Awesomer!! (And One Day I Will Figure Out Why This Works So Nicely )
Will mark as "solved."
Hi,
thanks for sharing very kind feedback.
Greetings from Italy
I was a little quick in designating as "solved."
Turns out that the source file has blank entries. I changed one of the date entries to blank in the attachment. Results in DIV/0.
Can this be fixed to recognize ignore blanks, or something magical?
Hi
a small fix
=SUMPRODUCT(((COUNTIF(B11:B13,A11:A100)=0)*(WEEKDAY(A11:A100,11)<6))/COUNTIF(A11:A100,A11:A100&""))
Please check if you'get unespected results.
Regards
It works nicely. (Have more thoroughly vetted, this time.
Grazie Mille!
Ciao,
thanks again!
Saluti dall'Italia
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks