Require previous working day minus public holidays

[troy79]

I am newish to MS Access.
I require the equivalent formula from excel to mc access which will workout -1 day from my data-set less weekends/public holidays.
So this is what i use in excel atm: =WORKDAY(start date,days,[holidays])
Any help would be greatly appreciated.

 

[CJ_London]

duplicate post here with answers

http://www.accessforums.net/showthread.php?t=62839

Please read this thread

http://www.excelguru.ca/content.php?184

 

[jdraw]

I agree with CJ -- when you cross post, advise people that you have done so.

See this material for more info on Business days.

 

[Ranman256]

You must fill a holiday table with all your holidays.
The. Run a query to remove them from the date calculation.