More for Date plus 10 working days thread

  • Thread starter Thread starter Diane-Maplewood
  • Start date Start date
D

Diane-Maplewood

Code from Arvin Meyer
http://www.datastrat.com/Code/GetBusinessDay.txt

Quick question-- how do I adjust this line, if I want to include Saturdays
(Just not include Sundays and Holidays). I can't seem to grasp the meaning
of "<>".

"If Weekday(datStart) <> vbSunday And Weekday(datStart) <> vbSaturday Then
If rst.NoMatch Then intDayAdd = intDayAdd - 1"

Thank you for your time and any info. -Diane
--------------------------------------------------------
Out of clutter, find Simplicity.
From discord, find Harmony.
In the middle of difficulty lies opportunity.
Albert Einstein
----------------------------------------------------------
 
<> is "not equal to"

If Weekday(datStart) <> vbSunday And Weekday(datStart) <> vbSaturday Then

says "If the day of the week for datStart isn't Sunday and it isn't Saturday
Then ..."

To include Saturday but exclude Sunday, use

If Weekday(datStart) <> vbSunday Then
 
Thank you Mr. Steele. It all makes sense now. Thanks for clearing that up
for me. Much appreciated!

-Diane
 
Back
Top