How to add years to a date field?

Hello Amanda, 

If the contact duration is always in years you could try something like this: 

addDays($date_closed,multiply($contract_duration_years_c,365))

This is close, but added 4 days when I need it to add 4 years. 

Can you share the exact formula that you are using?

addDays($initial_award_date_c,add($initial_years_c,365))

I believe you just need to change the add() to multiply(), something like this:

addDays($initial_award_date_c,multiply($initial_years_c,365))

Awesome, that worked thank you! My next question, can I use that field we just calculated to be in another formula?

Perfect, yes, you should be able to search for it in the field selector on the formula builder: 

Perfect, yes, you should be able to search for it in the field selector on the formula builder: