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

Maybe one of these CF can help

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

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

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

Case(

DayOfWeek ( yourDate ) = 1 ; yourDate - 17;

DayOfWeek ( yourDate ) ≤ 3 ; yourDate - 18;

yourDate - 16

)

Hi,

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

Robin

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

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.

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