Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Please help calculate the number of days between dates

  1. #1
    Board Regular wilkisa's Avatar
    Join Date
    Apr 2002
    Location
    Decatur IL, USA
    Posts
    635
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    We have two cells with dates, formatted as mm/yyyy. We have created a VLookup to find the number of days in each month. However, they have now decided to sum the number of days between the start and end dates. What would be the best way to do it? They do not like the DAYS360 function.

    Example:

    Start Date: 03/2002
    End Date: 07/2002

    I need to know how to get it to calculate the number of days between 3/1 and 7/31, resulting in 153. These dates will change so the formula needs to be based on the two cell references.

    Thanks for any help. I am leaving for the day but will check back in very early tomorrow morning.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,308
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hiya,

    =(EndDate - StartDate) with the cell formated as a number should give you the raw number of days.

    Adam

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,646
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-15 13:40, wilkisa wrote:
    We have two cells with dates, formatted as mm/yyyy. We have created a VLookup to find the number of days in each month. However, they have now decided to sum the number of days between the start and end dates. What would be the best way to do it? They do not like the DAYS360 function.

    Example:

    Start Date: 03/2002
    End Date: 07/2002

    I need to know how to get it to calculate the number of days between 3/1 and 7/31, resulting in 153. These dates will change so the formula needs to be based on the two cell references.

    Thanks for any help. I am leaving for the day but will check back in very early tomorrow morning.
    Simply:

    =B2-A2

    where B2 > A2, that is, B2 is the latest date.

    Format the formula cell as General.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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