+ Reply to Thread
Results 1 to 2 of 2

Need Excel to look at weekdays in a formula

  1. #1
    Registered User
    Join Date
    10-28-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    6

    Need Excel to look at weekdays in a formula

    Hi I have a formula in my worksheet that looks at a date of expected completion (cell c3) and date of actual completion (cell e3) and tells me how many days over or under it is (cell g3)
    but I need it to only take into account weekdays I am using the formula =IF(E3="","",C3-E3) could someone please tell me how this is done, Thank you in advance

  2. #2
    Forum Expert
    Join Date
    04-22-2013
    Location
    .
    MS-Off Ver
    .
    Posts
    4,418

    Re: Need Excel to look at weekdays in a formula

    =IF(E3="","",NETWORKDAYS(E3,C3))

    I think.

+ 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. Excel Formula to calculate working hours between two dates excluding weekdays with wh
    By breadwinner in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-28-2013, 11:20 AM
  2. Excel Count Weekdays Formula
    By Ziggy M in forum Excel General
    Replies: 9
    Last Post: 07-14-2006, 08:10 PM
  3. [SOLVED] Formula using weekdays calculations
    By Hall in forum Excel General
    Replies: 1
    Last Post: 03-22-2006, 06:50 PM
  4. [SOLVED] Excel Formula WEEKNUM only works on weekdays 1 and 2, why?
    By Geocyclist in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-09-2005, 10:06 PM

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