need query

hai everybody...

 I have information about the faculties and their  schedules.
 (ie)
 what are the batches?
 1.Who are the faculties?
 2.What are the tracks(ex.Java,Developer....) they are going to take?  what are the modules under the track java(ex..XML,Sevlets...)  3.in which place?
 4.In which date?
 when the batch going to start and end.  each batch has one or more modules....  Here i have a table which has the information about the  leave days...Table name is Holidays...
  jan 1 new year and jan 15 pongal..and so on

 i have created a form for inserting the data...  the forms has the following fields

 batch name:B001
 Faculty Name:S.Mitra
 Track Name : Java
 Location :Bangalore
 total no.of days:10
 Batch Start Date: 20-sep-01
 Batch End Date :
 module start date:20-sep-01
 module end date: this is when will XML end

 in this above form i have entered all the values  except MODULE START DATE,MODULE END DATE,BATCH END DATE  for example assume JAVA track has two modules  and each module takes 5 days each

 for exampla a module starts on say 20-sep-01(thursday) then the  end date shud be start date +5 for that module...but i want to  minus holidays(from holidays table)and also saturday's and sunday's  so if monday 24-sep-01 is a holiday(according to holiday table)  then want the query to return the end date to be 27-sep-01.

 i have already written an sql to find the end date minus the  holidays(from holidays table)..but i dont know how to minus  saturday and sunday also to get the end date

 thanks in advance
 ramola Received on Mon Sep 24 2001 - 01:14:42 CDT