J
Jean
I am trying to create a formula in a form filed that will take 2 dates, find
the total days between those dates, then substract 2 day for every 7
(weekends) and any holiday in between. I created a separate table for
Holidays through 2006.
Example: 01-Nov-2002 through 12-Dec-2002 = 42 days minus 12 days (2 for
every 7) and then any holiday for a true total in between = 42-12=30
I wouls appreciate any help
the total days between those dates, then substract 2 day for every 7
(weekends) and any holiday in between. I created a separate table for
Holidays through 2006.
Example: 01-Nov-2002 through 12-Dec-2002 = 42 days minus 12 days (2 for
every 7) and then any holiday for a true total in between = 42-12=30
I wouls appreciate any help