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.

To learn more, please see our Using Formulas in QuickBase help topic.

Comments

Formula for weekday without using Fridays

I am looking to create a formula that will calculate an installation date. The work can only be done during the work week, however the customer will not allow Friday work.

 

WeekdayAdd([Notification Date],+37)

 

However, I am not sure how to remove the Friday out of the weekday add. Any suggestions?

 

Thanks in advance

Hi Jason, You'll want your

Hi Jason,

 

You'll want your formula to detect when it's about to display a Thursday, and instead have it display the following day:

 

If(

 

// If the day of the week 37 days after Notiifcation Date is a Thursday, that's not valid, so add an extra day.

DayOfWeek(WeekdayAdd([Notification Date], 37))=4,

WeekdayAdd([Notification Date], 38),

 

// Otherwise, just add 37 days as usual.

WeekdayAdd([Notification Date], 37)

)

 

Thanks!

Brian

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.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit