Calculating Working days from set date

Posted on 2007-11-29
Medium Priority
Last Modified: 2012-06-27
Hi Experts,

I need to create a formula in CR8.5 that will calculate the number of working days back from a set date. ie;
if Condition = 3 then subtract 3 working days from enddate
else if Condition = 5 then subtract 5 working days from enddate etc

I am happy using the dateadd function to do the subtract but not sure on how to subtract only working days from the end date.

Any help appreciated

Question by:RangerLad
LVL 101

Accepted Solution

mlmcc earned 2000 total points
ID: 20384982
Here is a formula to calculate the work days between 2 dates.  Use it then subtract the 3 or 5 days from the result.


Expert Comment

ID: 20592594
Forced accept.

EE Admin

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Watch the video to learn how one can deal with PST file corruption issue with an outstanding Kernel for Outlook PST Repair Tool easily. Using this tool, non-technical users can swiftly perform the repair process to restore their essential data witho…
Did you know PowerShell can save you time with SaaS platforms? Simply leverage RESTfulAPIs to build your own PowerShell modules. These will kill repetitive tickets and tabs, using the command Invoke-RestMethod. Tune into this webinar to learn how…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question