Results 1 to 3 of 3

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

Threaded View

jgomez how to sum day if it falls in... 11-23-2011, 12:46 PM
alansidman Re: how to sum day if it... 11-23-2011, 04:24 PM
jgomez Re: how to sum day if it... 11-30-2011, 01:54 PM
  1. #1
    Valued Forum Contributor
    Join Date
    12-22-2010
    Location
    Texas
    MS-Off Ver
    Excel 2003 & Excel/Access 2007
    Posts
    438

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

    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...
    Last edited by jgomez; 11-30-2011 at 01:54 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1