+ Reply to Thread
Results 1 to 3 of 3

Workday syntax

Hybrid View

  1. 06-20-2012, 06:30 PM #1
    AlanF51MS
    AlanF51MS is offline
    Registered User
    Join Date
    05-23-2012
    Location
    Central Valley, CA
    MS-Off Ver
    Office 2010
    Posts
    14

    Workday syntax

    Hi,
    I have
    =DATE(YEAR(C3),MONTH(C3),DAY(C3)+D3+E3+F3+5) where the +5 is weekends and holidays

    I tried =workday(YEAR(C3),MONTH(C3),DAY(C3)+D3+E3+F3+0)
    I just can't get the sytax correct for my start date and adding the days, and once I get that correct I would like to add holidays.
    Thanks
    alan
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-20-2012, 06:42 PM #2
    protonLeah
    protonLeah is offline
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,922

    Re: Workday syntax

    It's: =C2+D2+E2+F2
    Today's date is the number of days since 1/1/1900 (41082). If you add 3 to it, Excel will convert that new number to a calender date, etc
    Last edited by protonLeah; 06-20-2012 at 06:45 PM.
    Ben Van Johnson
    Reply With QuoteRegister To Reply
  3. 06-20-2012, 07:08 PM #3
    AlanF51MS
    AlanF51MS is offline
    Registered User
    Join Date
    05-23-2012
    Location
    Central Valley, CA
    MS-Off Ver
    Office 2010
    Posts
    14

    Re: Workday syntax

    Quote Originally Posted by protonLeah View Post
    It's: =C2+D2+E2+F2
    Today's date is the number of days since 1/1/1900 (41082). If you add 3 to it, Excel will convert that new number to a calender date, etc
    But I want to use workday to skip the weekends and hopefully the holidays and the c2+d2+e2+f2 just gives me net calendar days
    Thanks
    Alan

    Edit,
    This does work
    =WORKDAY((C2),(D2+E2+F2))
    Thanks
    Alan
    edit2
    and this got the holiday
    =WORKDAY((C2),(D2+E2+F2),( J$2))

    Thanks!!
    Last edited by AlanF51MS; 06-20-2012 at 07:17 PM.
    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