# Formula to calculate ETA using a start date and number of days

Topic Labels: Formulas
Solved
1023 3
cancel
Showing results for
Did you mean:  4 - Data Explorer

I need a formula to calculate ETA (more like Estimated Day of Arrival) for animal breeding purposes. I have a column with number of days bred and a column for the date checked. The average gestation period is 278 days.
Is there a formula in which I could use the start date(ex: 9/11/2019), days bred (ex:84), and gestation length (ex:278) to calculate delivery day?

1 Solution

Accepted Solutions  7 - App Architect

The `DATEADD()` formula I think will do the trick here. I’m a little unclear how, or if, the days bred/date checked columns should affect the Estimated Day of Arrival. But for a simple Start Day + Average Gestation time = ETA formula, you could use

`DATEADD({Start Date}, {Gestation}, 'days')`

You can read more at the documentation if you would like: ### 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...

3 Replies 3  7 - App Architect

The `DATEADD()` formula I think will do the trick here. I’m a little unclear how, or if, the days bred/date checked columns should affect the Estimated Day of Arrival. But for a simple Start Day + Average Gestation time = ETA formula, you could use

`DATEADD({Start Date}, {Gestation}, 'days')`

You can read more at the documentation if you would like: ### 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...  4 - Data Explorer

Great! I was able to figure it out easily by tweaking the formula you provided. One more question. Is there a way to remove the time on that? It’s providing me with a day and time (12:00am) we don’t really need the time.

Thanks again!  7 - App Architect

Yes, if you go into the “Formatting” tab (right next to where you edit the formula), you’ll notice there’s an “Include a time field” option. If you’d like, you can also change how the date displays here as well.  