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.
Page 1 / 1
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
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!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.