Quickbase Discussions

 View Only

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

By Brian Cafferelli posted 01-23-2018 21:43

  


[The Quick Base Knowledge Base is your library of frequently-asked questions that help you better customize your apps to solve your business problems.]

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 Quick Base help topic.