locked
Balance Days to calculate (e.g Target date - current date = balance days RRS feed

  • Question

  • Dear All,

    Please i need to calculate the balance days in my tracking sheet i am trying to put the formula (target date cell - current date cell ,now() but not finding the balance days please help me for its simple problme.


    MS USER

    Monday, February 16, 2015 1:42 PM

Answers

  • Hi,

    I guess you are looking for a return of days right?

    Try this formula: =DATEDIF(NOW();A2;"D")

    Where now is your current date. Replace A2 with the cell which contains your Target date. The "D" is the argument that returs the number of days. Example:

    If A2 is set to target date 12-04-2015 and now is 16-02-2015 you would get a return of 55 days.

    Is that what you are looking for?

    Maurice


    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer. Thank You

    • Proposed as answer by George123345 Monday, February 23, 2015 2:53 AM
    • Marked as answer by George123345 Tuesday, February 24, 2015 3:22 AM
    Monday, February 16, 2015 10:31 PM