DATEADD but exclude Sundays

[Rishi_Goutam]

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

[Mohamed_Swella1]

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:

Move task on the monday when it's saturday or sunday? Formulas

You could simplify that a great deal with SWITCH() IF( AND({routine type}, {task date}), DATEADD({task date}, SWITCH( {routine type}, 'daily', SWITCH(WEEKDAY(DATEADD({task date}, 1, 'days')), 0, 2, 6, 3, 1), 'weekly', SWITCH(WEEKDAY(DATEADD({task date}, 7, 'days')), 0, 8, 6, 9, 7), 'bi-weekly', SWITCH(WEEKDAY(DATEADD({task date}, 14, 'days')), 0, 15, 6, 16, 14), 'monthly', SWITCH(WEEKDAY(DATEADD({task date}, 30, 'days')), 0, 31, 6, 32, 30), 0 ), 'days'))