What is the Excel formula to check if a date is the nth weekday of the month?
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:
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.
- garbo7441Lv 73 weeks agoFavorite Answer
Let's keep it simple:
=IF(AND(WEEKDAY(A1) = 2,AND(DAY(A1)>=8,DAY(A1)<=14)),1,0)