Date Field Calculation


#1

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.

Dates


#2

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


#3

Worked like a charm! Thanks!