Having trouble determining if a date is a workday or not from VBA

[Bezzie]

I have a future date generated by VBA. I need to test if this date is going to be a valid workday so that I can adjust my date accordingly.

I also have a range of public holiday dates in a sheet which should also be excluded, same as weekend dates. The Workday function of Excel seems to be the function to use as it can exclude the public holidays as well when these are passed as a range to the function but it doesn't want to tell me if the date is a workday or not. It can tell me what the next workday or the previous workday, from my date, will be but that's not what I need. I need it to tell me the day is a workday or not. Based on this I can then check to see if I want the next working day or previous working day.

Any input appreciated.

[Pepe Le Mokko]

Perhaps test with the WEEKDAY function ? If it returns a number >5 it is not a workday ( sorry I'm no good at VBA)

[Bezzie]

The Weekday function will not exclude public holidays. I need them excluded as well.

[Pepe Le Mokko]

It will allow you to check the result of the generated future day, although WORKDAY should return a workday as it says

[Bezzie]

Got a resolution. Add one day to the date and then check what the workday before that date will be with the WORKDAY function. Compare the returned date to the date I want to check and voila! If it's the same then the date is a workday.