What is the Excel formula to check if a date is the nth weekday of the month?

Hi all, 

I am trying to find a formula that returns "1" if it's second Monday of the month. So essentially the first column in the spreadsheet will be a list of date: Example: 

01/09/201702/09/2017

03/09/2017

---

1/10/2020

The second column right next to it will identify if the cell to its left is a second Monday of the month. if it is, a number "1" will be displayed, else will be "0".

Thank you very much for your help. 

1 Answer

Relevance
  • 3 weeks ago
    Favorite Answer

    Let's keep it simple:

    =IF(AND(WEEKDAY(A1) = 2,AND(DAY(A1)>=8,DAY(A1)<=14)),1,0)

    Attachment image
Still have questions? Get your answers by asking now.