DATEADD but exclude Sundays

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


I would like to add days to a start date but exclude Sundays. So if I have a Start Date, I want to estimate the End Date by adding some number of days to the Start Date while excluding days that fall on Sunday.

So if I have a Start Date of September 1 and add 7 days, I want to end up with September 9 rather than September 8 as I want to skip over the Sunday in the 7 days.

My formula is below:

Estimated End Date =
IF({Start Date},
{Start Date},

1 Reply 1

Hi @Rishi_Goutam ,

Welcome to Airtable Community !

You can refer to this Topic which had a similar issue. You can easily change the formula to fit your needs :slightly_smiling_face: