Not sure if possible to do in access but i'd like to count 15 days from today & if the day falls on Sat, Sun or if the 15th day is a holiday skip to the next working day. I got this for excel and it works fine:
=WORKDAY(TODAY()+15,1,$A$2:$A$13)-1
I'm trying to automate things so we don't have to input information ourselves. If the holiday part can't be done then at least skipping the weekends would be nice.
Again not sure if possible...
Bookmarks