+ Reply to Thread
Results 1 to 5 of 5

Number of Days Calculation

  1. #1
    Registered User
    Join Date
    06-05-2019
    Location
    Canada
    MS-Off Ver
    10
    Posts
    8

    Number of Days Calculation

    I for the life of me don't know why I am having such a hard time with this one as soon as someone answers this I'm going to be like of course! lol

    I have a Start Date and End Date I need the total number of days not the difference in days this is the formula I have so far..

    =(DAYS(U11,T11))+1

    However I want to carry the formula down to empty rows that do not yet have both start dates and end dates so if the date equals "1" because both start date and end date are empty I want it to return blank
    If there is only a Start Date currently it returns a negative value and I want it to return Blank in that scenario as well.

    I know there is multiple formulas to calculate the difference in days I'm not set on using this one specifically if there is a better one that works for this case.

    Thank you in advance for you help on this,

    Sugar

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,607

    Re: Number of Days Calculation

    Try this:

    =IF(OR(U11="",T11=""),"",U11-T11+1)

    Copy down as required.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    06-05-2019
    Location
    Canada
    MS-Off Ver
    10
    Posts
    8

    Re: Number of Days Calculation

    THANK YOU SO MUCH! I was trying to do the IF conditions at the end not the beginning smh I knew it was simple lol

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,607

    Re: Number of Days Calculation

    Glad to help, and thanks for marking the thread as Solved.

    You might also like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

  5. #5
    Registered User
    Join Date
    06-05-2019
    Location
    Canada
    MS-Off Ver
    10
    Posts
    8

    Re: Number of Days Calculation

    I did not know that, thank you for sharing =)

+ 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. Date Calculation for Number of Days Overdue
    By Sharr76 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-05-2021, 02:08 AM
  2. Calculation of a certain number of hours out of 24 over multiple days
    By Bernice75 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-11-2018, 05:02 AM
  3. Calculating number of days Calculation formula
    By Doofus1 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-02-2018, 12:19 AM
  4. Formula involve calculation of number of days
    By kiany406 in forum Excel General
    Replies: 3
    Last Post: 07-01-2015, 09:48 AM
  5. Replies: 3
    Last Post: 07-12-2010, 09:09 AM
  6. Number of Days Count/Calculation?
    By JonHook in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-02-2007, 05:32 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