Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

DATEADD but exclude Sundays

Topic Labels: Formulas
1032 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: