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 pr

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