Remove Every Other Friday
 

Well, I am working with Crystal Reports. I know that it can b
programmed using Basic Syntax. I cannot find the answer I am lookin
for and was hoping some here could help.

I need to take evey other friday out of the my equation.

I have queues and when an item is moved to a different queue it is tim
stamped with a start date. I am then taking the start date an
subtracting Saturdays and Sundays. Now I am faced with trying to tak
out my off fridays with fall every other friday.

Is there a way to give a known friday off and then count the friday
off and subtract them from the given start date?

i.e Start Date = (07/25/06) - (07-28-06) - (08-11-06)
**
The formula I have in the currently is as follows and it takes out th
saturdays and sundays

DateDiff("d",{ITEM_QUEUE.START_DATE},(CurrentDate) )-
DateDiff("ww",{ITEM_QUEUE.START_DATE}, (CurrentDate)
crSaturday)-
DateDiff("ww",{ITEM_QUEUE.START_DATE}, (CurrentDate), crSunday)

If anyone can put me on track to figuring this out much would b
appreciated.:eek

--
zero63
-----------------------------------------------------------------------
zero635's Profile: http://www.excelforum.com/member.php...fo&userid=2480
View this thread: http://www.excelforum.com/showthread.php?threadid=57265