how to sum day if it falls in a weekend or holiday?

**jgomez** · 11-23-2011, 12:46 PM

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...

**alansidman** · 11-23-2011, 04:24 PM

This video will give you some basics on selecting only non holiday weekdays. You will have to amend it for your +15 days and skip to next weekday, but it should not be difficult. Create your query and if you get stuck, post back with your SQL statement and what you want to accomplish and the expected results and we will help you achieve your solution.

http://www.datapigtechnologies.com/f...yworkdays.html

Alan

**jgomez** · 11-30-2011, 01:54 PM

I'm not good at VBA, SQL or much of anything but I figured out how to work this out. If any of you know a good starting book or article let me know.

the attached excel sheet has three columns. Column A has todays date until the year 2020. Column B has federal holidays from this year until 2020. Column C calculates 15 days from day in column A & excludes weekends & adds another day if the 15th day happens to be a holiday.

I uploaded the attachment into access & linked it to a table i had there that has date() as one of the fields so everyday it will give me what i need.

hope it helps & makes sense.