• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 512
  • Last Modified:

Calculating Working days from set date

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

Thanks
RangerLad
0
RangerLad
Asked:
RangerLad
1 Solution
 
mlmccCommented:
Here is a formula to calculate the work days between 2 dates.  Use it then subtract the 3 or 5 days from the result.
http://www.kenhamady.com/form01.shtml

mlmcc
0
 
Computer101Commented:
Forced accept.

Computer101
EE Admin
0
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

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now