Calculate Reverse Date Format

Hi dears if someone can help with this format I have 3 cells:

1-ESTIMATED REQUIRED DELIVERY DATE: include the estimated date of delivery

2-PROCUREMENT TIMELINE: autogenerated including the number of working days

3-PR ESTIMATED SUBMISSION DATE: I need to create a formula that can automatically calculate the reverse date of working days only "not including weekends Saturday and Sunday" , the value of the cell will be a date calculated as ESTIMATED REQUIRED DELIVERY DATE - PROCUREMENT TIMELINE excluding weekends

Thank you in advance

Find more posts tagged with

Sheets

Support

Solution Center

Project Management

Accepted answers

All comments

Antonio Figueroa

Good Morning

=[Estimated Required Delivery Date]@row + NETWORKDAYS([Estimated Required Delivery Date]@row, [Estimated Required Delivery Date]@row + [Procurement Timeline]@row)

Hope this helps

Alim

Thank you for your feedback, it works but I'm facing another problem:

PROCUREMENT TIMELINE value is formula "=IF([ESTIMATED VALUE]10 >= 50001, "60", IF([ESTIMATED VALUE]10 = 0, "", IF([ESTIMATED VALUE]10 >= 20001, "25", "14")))"

If I didn't change the cell value manually to number the date template PR ESTIMATED SUBMISSION DATE showing an error #INVALID OPERATION

So how I can fix that without removing the IF formulation?

Thanks

Alim

OK i Solved thank you for your support

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.