Formula for excluding weekends for an end date

I have searched and attempted the WORKDAY formula without success.

I have a schedule that populates from this source and we have columns as shown.

to get the Est Finish Date i used formula =[Planned Install Date]@row + [Total Man Days]@row

This worked great except we dont work weekends and i would prefer if we can show the schedule report calendar that reads from this source not to include weekends. I looked at attempted to do workday and networkday formulas but seem to get an error. So there is a missing formula somewhere that i need help on.

My second part of this question is it possible to have within the formula to divide the man days in the column in 2/3/4 based on sizes.

IE: <10 man days divide by 2. 10-20 man days divide by 3 and 20+ man days divide by 4.

If thats not possible that is fine, i am mostly concerned with excluding weekends from the est finish date results on the calendar.

Here is a screenshot of the calendar view i am referencing wanting to remove the weekends.

Find more posts tagged with

Accepted answers

All comments

Corey W.

@SC8713 Howdy. I think you want to use WORKDAY(). It uses a start date and the number of working days and returns the date. You can also include holidays in the function for exclusion if needed.

For the second part of your questions, you could def. do it with a helper column. There may be more elegant ways though.

SC8713

https://community.smartsheet.com/discussion/comment/490033#Comment_490033

while it creates the end date as week day total end date it does not reflect on the calendar side. It still remains showing it spanning the weekend.

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.