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.
To learn more, please see our Using Formulas in QuickBase help topic.