Creating Date 9 Months Away

General FAQs
, ,
1

Hello, I need some assistance creating an automation or even a formula to auto populate a date. Our company offers referral bonuses once an employee has been with us for nine months. So what I need, is for my “Referral Date” column to auto-populate the date that is nine months from the date I have plugged in to the “Onboard Date” column. Basically, I am wanting Monday.com to do this math for us, but haven’t been able to figure it out.

image

2

Hi @madalyn,

Try a formula column with the following syntax:

FORMAT_DATE(DATE(YEAR({Onboard Date}), MONTH({Onboard Date}) + 9, DAY({Onboard Date})))