Date Field Calculation


I have two date fields, Date A and Date B. Date B is always exactly 5 days after Date A. Right now I manually enter both dates, but I would like to create a formula in the Date B field so that Date B will automatically populate as Date A + 5 days.



This is the formula you would need…

DATEADD(Date A, 5, ‘days’)

Refer this page for a more detailed explanation of all the different date formulaes


Worked like a charm! Thanks!