
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 06, 2022 10:18 AM
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())

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 06, 2022 10:43 AM
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:
