Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Posts
    150

    Unanswered: Need Help with a Weekday Formula

    Hello Experts,

    Hoping that someone can assist me with this Weekday formula that I need.

    I have two columns, an Actual date and a Due date. I would like to see the difference between the two dates, but I only need the weekdays, not the entire 7 days.

    I created a formula using the “Today()” function, but that gives me 7 days.

    How can I get the number of days between Actual and Due date in Weekdays?

    Here is my formula:

    =IF(ISBLANK(P3),"",R3-TODAY())

    Here are my two columns:

    P3 R3
    Actual Date Due Date

    I am using Excel 2010, Office 7

    Thank you. :-)

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    There's a function called DateDiff() that accepts a weekday parameter (VBA)
    There's the inbuilt DateDif() but I don't know if that does weekdays.

    Alternatively some quick google-fu returned this: http://support.microsoft.com/kb/821091
    George
    Home | Blog

  3. #3
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    Also could be worth a read: Count Days Between Two Dates in Excel
    George
    Home | Blog

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •