+ Reply to Thread
Results 1 to 2 of 2

Date formula

  1. 10-30-2006, 05:34 AM #1
    dyanong
    dyanong is offline
    Registered User
    Join Date
    10-30-2006
    Posts
    3

    Date formula

    We're making a production schedule and would like to skip sunday in drawing dates back. Networkdays skip weekends (both saturday and sunday). Is there any other date functions which workdays can be customized?

    THANKS!
    Reply With QuoteRegister To Reply
  2. 10-30-2006, 05:46 AM #2
    Bryan Hessey
    Bryan Hessey is offline
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by dyanong
    We're making a production schedule and would like to skip sunday in drawing dates back. Networkdays skip weekends (both saturday and sunday). Is there any other date functions which workdays can be customized?

    THANKS!
    =IF(WEEKDAY(A1)<7,A1+1,A1+2)

    should list all days except Sunday

    hth
    ---
    Si fractum non sit, noli id reficere.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1