Need a formula to add/subtract calendar days to a date to create a new date

Smartsheets seems to be defaulting to adding/subtracting business days, but I want the formula to use calendar days instead, how do I do this?

My current formula is =[Planned End Date]1 - 195. But I want it to be 195 calendar days, not business days. How do I change it to be calendar days?

Find more posts tagged with

Formulas

Accepted answers

All comments

Paul Newcome

Doing it that way should be calendar days. Can you provide a screenshot of a few entries where this is calculating business days instead of calendar days?

Boots

Okay yes, you're right! 3/20/24 IS 195 calendar days prior to 10/1/24, and is 140 business days prior to 10/1/24, not considering holidays, so I think I'm good. I just have to remember duration will calculate my planned end date using business days, not calendar days.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.