• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 383
  • Last Modified:

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
0
lcor
Asked:
lcor
1 Solution
 
TracyVBA 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now