+ Reply to Thread
Results 1 to 5 of 5

Working days inside a table *AND* with an IF statement

  1. #1
    Registered User
    Join Date
    06-14-2013
    Location
    NYC
    MS-Off Ver
    Office 365.....
    Posts
    13

    Working days inside a table *AND* with an IF statement

    Maybe I'm going about this the wrong way? I'm taking a previous coworkers sheet and trying to modify and update and upgrade it to meet my needs. The sheet itself is a little more involved but I did a sample to share. Basically this is somewhat of a construction schedule and I'm trying to list an expected and an actual date for several deliverables and try to run out and calculate the schedule based on either the expected date or, if there is an actual date, that date. The formulas I have and modified work fine..... but I'm trying to calculate these on WORKING days and not just CALENDAR days. Maybe I'm trying to combine too many functions and it's not possible? Hopefully it is possible. I'm attaching the sheet for the gurus here to hopefully maybe help me out. I searched but only saw a varying combination of results none of which combined everything that I think I'm trying to do here.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    06-21-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    191

    Re: Working days inside a table *AND* with an IF statement

    Try this:
    =IF([@Actual]<>"",WORKDAY([@Actual],3),IF([@Expected]<>"",WORKDAY([@Expected],3),""))

  3. #3
    Registered User
    Join Date
    06-14-2013
    Location
    NYC
    MS-Off Ver
    Office 365.....
    Posts
    13

    Re: Working days inside a table *AND* with an IF statement

    Perfect, thanks! Now.... I just noticed that it "autofills" for all of the column going down. Is there a way to separate these? Like for example, I might want one row (steel for example) to have deliverable #3 5 days behind but I want another row (drywall) to be 8 days behind. Is there a way to separate these so that I have different durations?

  4. #4
    Forum Contributor
    Join Date
    06-21-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    191

    Re: Working days inside a table *AND* with an IF statement

    Yeah. When I selected the Table (A3:I9), there was a little icon that popped up in the middle of it. Click that icon and select "Stop Automatically Creating Calculated Formulas"

  5. #5
    Registered User
    Join Date
    06-14-2013
    Location
    NYC
    MS-Off Ver
    Office 365.....
    Posts
    13

    Re: Working days inside a table *AND* with an IF statement

    For whatever reason the icon wasn't coming up for me. I went into excel help and found it. I'm guessing different version of Excel.

    Under File and then Options and then Proofing and then AutoCorrect options and then AutoFormat as you Type and then there is an option to turn off the fill formulas as you type.

    Thanks for the help. Now, to get to work....

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count 6 working days (excluding Sunday, Holidays & half days)
    By eve_star1 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-29-2015, 08:00 AM
  2. [SOLVED] Can You Put An IF Statement Inside a REPLACE Statement?
    By nevi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-21-2014, 07:34 AM
  3. Calculate total working days and excepted leave days
    By megaiooo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-21-2013, 09:29 AM
  4. Using a VLOOKUP and IF statement inside an IF statement
    By Isis3 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-08-2011, 07:04 PM
  5. If statement to include working days, exclude holidays
    By rhudgins in forum Excel General
    Replies: 2
    Last Post: 05-27-2010, 09:46 PM

Tags for this Thread

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