Well, I am working with Crystal Reports. I know that it can be programmed using Basic Syntax. I cannot find the answer I am looking 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 time stamped with a start date. I am then taking the start date and subtracting Saturdays and Sundays. Now I am faced with trying to take out my off fridays with fall every other friday.

Is there a way to give a known friday off and then count the fridays 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 the 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 be appreciated.