Help

Re: Date Field Calculation

906 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Bobby_Buckner
4 - Data Explorer
4 - Data Explorer

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 Replies 2
Andrew_Johnson1
8 - Airtable Astronomer
8 - Airtable Astronomer

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

Formula field reference

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...

Worked like a charm! Thanks!