formula

Syndicate content

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)

February 5th, 2009 - 6:02 PM

This can happen because the field property for [num1] called "Treat blank as zero in calculations" is checked. This is checked by default, so you can do things like add and subtract lists of values which contain some blanks.

February 5th, 2009 - 6:02 PM

© 1997-2014 Intuit Inc. All Rights Reserved.

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