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

    Unanswered: Calculate Number of Days between Dates

    Hello,

    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
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    does excel have either the datediff or similar function?
    Date and time functions (reference) - Excel - Office.com
    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
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    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.

Posting Permissions

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