How to find 2nd and 4th Sat of the month
Learn date function for isolating 2nd and 4 Sat from the month
full formula working in link • Excel Hacks: Finding the Nth Weekday Like ...
TIME CODES
00:00 - INTRODUCTION
01:12 - WRITING FORMULA
3:21 - FINAL FORMULA 1st_date_of_month+nth_weekday*7-WEEKDAY(1st_date_of_month-7-weekday_sequence_1to7SUN2SAT