Skip to main content

Is it possible to create a formula that tells you how many of a specific day of the week are in a month? Such as how many Wednesdays are in this month? I have a specific deliverable that needs to be done every Wednesday. I’d like a formula that would help me see how many of these are left in the month. Thanks!

Several people figured out different ways of doing this in this thread from 2 years ago:



Several people figured out different ways of doing this in this thread from 2 years ago:




Perfect! Thank you …


Reply