I need to calculate a future date looking at only weekdays and excluding holidays in an Access 03 query

Tables:
Leadtimes in workdays - contains # of work days that need to be added to current date to get future date

Holidays - current year holidays

I'm not very knowledgeable in VBA and I've found several posts and gotten close, but nothing is working. Any help would be greatful!

You should try to get a calendar of the holidays specific to your country (official holidays vary among countries) and enter the significant part of it into a table. Several solutions are available on the net.

From there you can compute the number of holidays for a given period and substact it (plus the weekends) from the total number of days for the same period. This would give you the number of workdays for the period.