If there is a weekend in the time span, then the dates will be five days apart, so that sounds correct to me?
Thursday 20th
Friday 21st 1st week day.
Saturday 22nd not counted.
Sunday 23rd not counted.
Monday 24th 2nd week day.
Tuesday 25th 3rd week day.
If this is not the correct result, then we need to define the requirement more precisely.
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- DateDiff to determine number of weekdays past? Shannon Carr
- RE: DateDiff to determine number of weekdays past? Barney Boisvert
- RE: DateDiff to determine number of weekdays past? Ian Skinner
- Re: DateDiff to determine number of weekdays past? Shannon Carr
- RE: DateDiff to determine number of weekdays past... Philip Arnold
- Re: DateDiff to determine number of weekdays ... Shannon Carr
- MS Access as a backend database Ian Skinner
- MS Access as a backend database David Brown
- RE: MS Access as a backend database Philip Arnold
- RE: MS Access as a backend database Tony Weeg
- Re: MS Access as a backend database Eric Dawson
- CF (BD) on CD with DB Success! Dick Applebaum
- Re: CF (BD) on CD with DB Su... Spectrum Web
- RE: CF (BD) on CD with DB Su... Yves Arsenault
- RE: CF (BD) on CD with DB Su... Tom Kitta
- Re: CF (BD) on CD with DB Su... Dick Applebaum
- Re: CF (BD) on CD with DB Su... Dick Applebaum