Calculating Days

L

learning_codes

Hi,

I learn how to use number of working days VB Code to generate the
numbers. It looks good.

I'm trying to understand how to create it but I could not do it. Your
help would be much appreciated. I use Start Date to End Date like
February 1, 2006 to February 28, 2006 that give 20 days. I have a
report that show only date is February 28, 2006 and some blank date.
If the date is blank, it give me number of hours.

Problem #1 : I create a query to count backward on February 28, 2006
(20 days) but I didn't realize that it give the answer to February 9,
2006 instead of February 1, 2006. I'm trying to exclude Saturday and
Sunday and it should be on February 1, 2006 NOT February 9, 2006.

Problem #2 : Similiar to Problem #1.....On the report, it shows me # of
working hours but no startdate. Example: I have 300 total working
hours and 15 hours per working day. Same thing with #1 and I want to
count backward on February 28, 2006 as EndDate and it should be
February 1, 2006 as StartDate.

Your help would be much appreciated.
Thanks
 
Top