Apr 18, 2018 07:55 AM
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.
Apr 18, 2018 08:09 AM
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
For an overview of formula fields, please refer to the Guide to Formula, Lookup, Count, and Rollup fields. Formulas may involve functions, numeric operations, logical operations, and text operation...
Apr 19, 2018 01:31 PM
Worked like a charm! Thanks!