Require previous working day minus public holidays

[troy]

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]

there isn't a formula as such, it has to be done with vba code. If you look to the bottom of this thread you will see at least two threads on the same subject.

Take a look at those and understand them and try them, then come back with a question if it is not working as you require.

[CJ_London]

also found this thread that refers to calling the workday function (or any function) from excel to be used in access

https://msdn.microsoft.com/en-us/lib...ffice.12).aspx

it covers how to get your data into a form suitable to be used by the function. in essence

Function UseExcelWorkdayFunction() as long
'install excel xx.x object library in references
Dim xl As Excel.Application

... 
...
get your data into form required
...
...

Set xl = New Excel.Application

UseExcelWorkdayFunction = xl.WorkDay(start date, days, [Holidays])

set xl=nothing

End Function