weekdays calculation

[RobinReumers]

Hi,

I have a date entered and now I want to calculate another date 12 workdays before the entered date, what would be the best way for this please?

Thanks

Robin

[mr_vodka]

Maybe one of these CF can help

http://www.briandunning.com/cf/385

http://www.briandunning.com/cf/353

[Lee Smith]

The CFs will give you a raw calculation of workdays. However, there are other factors involved that you should consider, such as holidays. If you want to account for holidays, then you should take a look at the example file by BobWeaver called WorkDay (in the sample file Topic Area).

HTH

Lee

[Raybaudi]

Case(

DayOfWeek ( yourDate ) = 1 ; yourDate - 17;

DayOfWeek ( yourDate ) ≤ 3 ; yourDate - 18;

yourDate - 16

)

[RobinReumers]

Hi,

http://www.briandunning.com/cf/385 is perfect, thank you very much, I don't need anything for holidays, this is perfect....

Robin

[Joseph31]

Can you show me how to show only a business days (5 day work week) not all days. Here is my equation that I use:

Get(currentDate) - Broker_Date

Any thoughts?

Joseph

[mr_vodka]

Wasnt the question answered here?

This thread is the one that I pointed you out to. Since you dont have Advanced, look at the second thread.

[Joseph31]

Thank you I see it now just missed it...

It works great --- It counts the current day --- is there a way not to do that?

Joseph