+ Reply to Thread
Results 1 to 2 of 2

Workday function - 6 day workweek

  1. #1
    Registered User
    Join Date
    10-13-2006
    Posts
    1

    Workday function - 6 day workweek

    I have been using the workday function for scheduling, but now we have accelerated to a 6-day workweek. Is there a way I can define the workweek?

    thanks for the help

  2. #2
    Valued Forum Contributor
    Join Date
    03-25-2004
    Location
    Boston, MA US
    Posts
    1,094
    lblake25,

    Try,

    =IF(WEEKDAY(A1,1)=6,WORKDAY(A1,1)-2,WORKDAY(A1,1))

    Where A1 is your start date. This assumes that your 6 day week is M-Sat.

    HTH

    Steve

+ Reply to Thread

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