Auto name tabs with dates excluding weekends and holidays

[Eeyora]

I am trying to run a macro to put in the Month, Day, Year on each tab but I want it to exclude holidays and weekends. I am not a techie or anything but I would like to know how to do this. I have tried various vb codes but they don't exclude the weekends/holidays. Thanks

[FDibbins]

I will move this to the VBA forum for you

[notreallyIT]

Ill give my ideas before someone more qualified has time to help...

If you set a variable as format(date,"dddd") this will give you the DAY of the week, you can then use an if statement to avoid weekends. I would imagine holidays would need to be listed somewhere as reference.

Hope this helps

[LJMetzger]

See the attached worksheet that should do what you want.
It is more involved than I had hoped, since I wasn't able to (i.e. I am not skilled enough) to adapt the Excel 'Workday()' function to my needs.

Lewis

The code in the worksheet follows:

Please Login or Register  to view this content.