Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Jun 18, 2020 04:53 PM
Hello, I use this formula to compute the projected funding date for a borrower. the Funding date is usually 3 days after the borrower signs the final documents. This formula does it just fine, but I need to exclude Saturdays and Sundays from the formula. for example, if a borrower signs on Monday the 15th, then he should be funded on Thursday the 18th. However if the borrower signs on Saturday the 20th then he should be funded on Wednesday the 24th.
Please note, signings can be done on saturdays, but funding can not.
existing formula.
DATEADD({Signing Dt/Tm},3,‘day’)
thankyou in advance
Solved! Go to Solution.
Jun 18, 2020 05:31 PM
Hi @Bridget_Ruiz,
You would use the WORKDAY function for this:
WORKDAY({Signing Dt/Tm},3)
You can also have this function skip over holidays, but you’d have to hardcode in every single holiday date that you want it to skip over. More details on the formula field reference page here:
Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:
Jun 18, 2020 05:31 PM
Hi @Bridget_Ruiz,
You would use the WORKDAY function for this:
WORKDAY({Signing Dt/Tm},3)
You can also have this function skip over holidays, but you’d have to hardcode in every single holiday date that you want it to skip over. More details on the formula field reference page here:
Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slightly_smiling_face:
Jun 18, 2020 09:25 PM
Thank you, but the formula you gave me didn’t work. The formula I already have works fine, I just need to find a way to incorporate the workday formula into it.
Jun 18, 2020 11:05 PM
My formula gives you EXACTLY what you asked for: 3 work days in the future from your {Signing Dt/Tm} field. That’s exactly what you asked for, and that’s exactly what my formula gives you. If you’re looking for something different, then please let me know what you’re looking for.
Jun 19, 2020 07:48 AM
Apologies, the formula was a valid formula, but for whatever reason, it did not compute the correct dates.