Help

DATEADD but exclude Sundays

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

Hi,

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},
DATEADD(
{Start Date},
ROUNDUP({Scope}/1000,0),
‘days’),
BLANK())

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: