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

    Unanswered: Calculate Number of Days between Dates


    How do you calculate the number of days from a status date to the current date?

    I have a “Current Status” column and a “Status Date” column in Excel (2010). I would like to see how long an item was placed in a particular status mode.

    For example, Current Status is “Work Completed” and the Status Date is 4/1/13. The next step from Work Completed is “Job Invoiced”. So, I would like to see how days this item has been in “Work Completed” status.

    I want to calculate the number of days between the “Status Date” and current date (Now).

    I hope this was not confusing.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    does excel have either the datediff or similar function?
    Date and time functions (reference) - Excel -
    suggest not, but MS Excel: DATEDIF Function (WS) suggests Excel does
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 17
    As Excel stores dates as numbers, you can simply subtract one date value from another. However, it also tends to set calculated cells to inherit their format from the parents, so you will need to manually change this (unless you want to see a three day period displayed as 03 Jan 1900).
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Posting Permissions

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