How to calculate the third friday of a month?

P

Peo Sjoblom

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

with any date in A1 will return the third Friday of the month

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use/create code in MS Word to calculate age? 0
How to implement two shifts per day with multiple teams 0
Access form continuous 1
How to Create an S-Curve from Custom Field? 0
I figured out the issue thank you. 0
Creating a Search using a combo box and then creating a report. 4
Replacing a phrase with carriage returns 1
Treating multiple paragraphs as one 2

Top