days

[johny.cbi]

Data Base: oracle

I want to create a caluclated column for ship date and req ship date
I am using the following syntax

(_days_between ([ship Date],[Req Ship Date]))

but I want to exclude saturdays/sundays/holidays

for eg:- aug 11 is the req date, aug 8th is the shipped date
the difference between these two dates is 3 days

but answer should be 1 day ( Aug 9 and Aug 10 are holidays)

appreciated for your reply

[blom0344]

If it is just the weekend you want to skip , then a calculation may be in order.
However, holidays are irregular.
The best solution is to use a calender file with a counter that increments for each regular working day.
You can design this in a spreadsheet and upload it to a table for reference purposes..