+ Reply to Thread
Results 1 to 7 of 7

Need help determining a total number of days from various due dates

  1. #1
    Registered User
    Join Date
    12-16-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007
    Posts
    4

    Question Need help determining a total number of days from various due dates

    I am trying to find a formula that will add or count days between today's date and various due dates to give me a total number of days. I attempted to use the datedif function and just adding each cell together and it works, but due to several columns being blank it creates an error, besides taking forever to build the formula one at a time.

    I attached a screenshot of what I'm working on.



    excelhelp.JPG
    Last edited by bex77; 12-16-2013 at 08:28 PM.

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,067

    Re: Need help determining a total number of days from various due dates

    Hi bex77,

    You can get a number figure just by subtracting the newst date from the oldest date & converting the format to a number.

    Hth
    Remember you are unique, like everyone else

  3. #3
    Registered User
    Join Date
    12-16-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Need help determining a total number of days from various due dates

    I need the total number of days added together though. The answer should be 44 in the screenshot that I included.

  4. #4
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Need help determining a total number of days from various due dates

    Oh, I get it now......

    Try this formula

    =SUM(J3:M10)-TODAY()*COUNT(J3:M10)

    format result cell as general
    Last edited by daddylonglegs; 12-16-2013 at 08:42 PM.
    Audere est facere

  5. #5
    Registered User
    Join Date
    12-16-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Need help determining a total number of days from various due dates

    Sure! Today's date is the 16th of December. I have 5 due dates in 7 days on 12/23 = 35 days. Then I have 2 due dates on the 31st (in 15 days) = 30. Then I have one way over due by 21 days, so it ends up being 35+30-21 = 44.

  6. #6
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675

    Re: Need help determining a total number of days from various due dates

    Yeah, sorry, I worked that out eventually, I didn't think you were counting the November date - see the formula I posted in my previous reply.....

  7. #7
    Registered User
    Join Date
    12-16-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Need help determining a total number of days from various due dates

    It worked perfectly!! Thanks so much!

+ 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] Adding Total Number of Days Elapsed and Displaying >31 Days
    By cwwazy in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-03-2013, 08:18 AM
  2. Determining number of specific days in period
    By MJohnston in forum Excel General
    Replies: 3
    Last Post: 06-25-2009, 01:57 PM
  3. Determining the number of specific days between two dates in Excel
    By jon s in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 03-21-2005, 06:06 PM
  4. Determining number of days between dates
    By Debbie in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-19-2005, 09:06 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