Results 1 to 3 of 3

Workday syntax

Threaded View

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

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