Excel Macro 3rd Friday Month

Is there a formula/macro which can do the following?

For each month of the year, give me the date of the third Friday of each month
lcorAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
TracyConnect With a Mentor VBA DeveloperCommented:
Yes, try this formula, adapted from the below link.  See attached.:

=DATE(B1,A1,1+7*3)-WEEKDAY(DATE(B1,A1,8-6))

http://www.excelforum.com/tips-and-tutorials/398194-calculating-the-date-of-the-nth-specific-day-of-the-month.html
Book1.xls
0
 
lcorAuthor Commented:
Perfect!
0
All Courses

From novice to tech pro — start learning today.