Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Formula that adds up to one month and that the final result is not a weekend

810 1
cancel
Showing results for 
Search instead for 
Did you mean: 
RaulGarcia
4 - Data Explorer
4 - Data Explorer

Hi Everyone!

We need to create a formula in airtable that from the column of the image (date of hire) where it indicates the day that the employee has been hired add 1 month and that the result is the first Tuesday of each month taking into account that each month has different days. And if it can be indicate us how to edit the formula to make that instead of Tuesday falls on Wednesday for example.
I don’t know if I make myself clear.

Thank you so much!!

P.D: Here is the formula I am trying and the column which I need to add one month.

image
Captura

2 Replies 2

Hey Raul,

Try using WORKDAY() or WORKDAYDIFF() in your formula

Here’s more info on the 2

______________________________________
Hannah - On2Air.com - Automated Backups for Airtable

Thank you very much Hannah. I will try it later to see if it works. Best regards!!!