Formula to work out number of days before another

Topic Labels: Formulas
852 4
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I’m looking for a formula that where I can have a field (1) with a start date in, a second field where I can add a number to represent days (3 days, 4, days, 10 days etc) and then another field where the formula is to calculate the specific days before field (1). Please tell me is exists! :winking_face:

4 Replies 4

Hm, would you be able to provide some examples for this?

E.g. if the start date is 9 November and we’ve added 3 days to it, it’ll show 12 November in the first field

What would the second field show at that point?

Thank you. The second field would auto calculate with whatever 3 days after the first. Does that make sense?

So three fields…. The third would have the formula.

1 November 3 4 November

Ah, I misunderstood you, sorry!

If that’s the case Nachliel_Pokroy’s answer above would work perfectly for you, and here’s a base where you can see it set up

Screenshot 2022-11-11 at 4.50.55 PM

4 - Data Explorer
4 - Data Explorer

Ah thank you both sorry I didn’t get the previous notification. I’ll have a try. Appreciate it!