Finding the 1st business day excluding weekends/holiday

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone have suggestions? I am trying to create an expression that
evaluates the current date and determines whether or not it is the first
business day of the current week. I've seen examples for 1st day of the
month, last day of the month, etc., but not much pertaining to weekly
increments.
 
Hello.

Im looking for examples of the 1st day of the month function.

You mentioned you seen this, can you point me in the right direction?
 
First day of the month is DateSerial(Year(DateToUse), Month(DateToUse), 1),
where DateToUse is the variable containing the date.

In case you need it, last day of the month is DateSerial(Year(DateToUse),
Month(DateToUse) + 1, 0)
 
Current date is found with the Date() function.

WeekDay(Date()) <> vbSaturday Or vBSunday determines if the current date is
a weekday.

You need a table of holidays. If Date() is not a holiday date in the table
then Date() is not a holiday.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)




"Finding the 1st business day excluding w" <Finding the 1st business day
excluding (e-mail address removed)> wrote in message
 
Back
Top