DATEADD but exclude Sundays

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())

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 :slight_smile:

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.