Automation is adding an extra day when creating a ...

[Lawrence_Ames]

Column A has a Date. I want column B to be the Date in Column A + 18 days.

I can’t figure out how do to this. Help!

Lawrence

[Elias_Gomez_Sai]

You have DATEADD function:

Airtable - Support

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

[Lawrence_Ames]

I did that, it only sort of works – it adds the date and the time.

I just want the Date shown.

Possible? Thank you!

[Jeremy_Oglesby]

Use the “Formatting” menu in the field options to remove the time display.

[Lawrence_Ames]

THANK YOU!! Ugh, I’m such a rookie. Thank you!