302 Found

Found

The document has moved here.

Knowledge Base

Our Knowledge Base covers a wide variety of technical topics, from the basic to the complex.

How do I make a formula to calculate the third Friday of the current month?

Here is a formula that will calculate the third Friday of the current month:

NextDayOfWeek( FirstDayOfMonth(Today()) - Days(1), 5 ) + Weeks(2)

It can be broken down to the following steps:

1) find the first day of the month containing today
2) go back one day to the last day of the previous month
3) find the next Friday (the number 5 represents Friday)
4) add two weeks to that to get the third Friday

You have to go back one day from the first day of the month because the function NextDayOfWeek() starts the search with the next day after the one given.

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.
302 Found

Found

The document has moved here.