Formula to Calculate Remaining Days without Weekends

[Katherine_77]

Can someone help me to solve this issue I have

How to calculate :

1. Doc_Date (Start Date) - Close Date = Remaining Days (with deduction of Saturday and Sunday) --> Key important
2. With considerations 3 different commit dates
3. With considerations of the High/Medium/Low (in days)

[ChemistB]

Not sure what you are looking for? Close date – Start date doesn’t give “Remaining days”
(Maybe Expected close date – today()?)
How do points 2 and 3 enter into this formula? How do they restrict it?

Ideally, upload a workbook.
Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
To Attach a workbook, “Go Advanced” then scroll down to “Manage Attachments.” Should be self-explanatory after that.

Remember to desensitize the data.

Last but not least, please change the title of this thread.
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?).

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[AliGW]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I have attempted to change it for you this time.)