Hello

Currently I was making a program that will store staff holidays, with a form they can fill out when they take some.

The form has Holiday Start and Holiday Finish as 2 Date Fields.

Also 7 Check boxes(Monday to Sunday) so they can tick which days they would normally work.

The problem i have is then we need to know how many days are being taken, for example.

If they choose
From 14/12/2010 To 16/12/2010
This is
14th.Tuesday 15th.Wednesday 16.Thursday

But they have ticked they only work Tuesdays and Thursdays this means they would have only took 2 days holiday.

How could i calculate this say if an employee took 1 month?
Would i have to check everyday/date? or is there a more efficient way?
Any help Appreciated

Thanks,
-Dual