I need help with Excel Formula?

Question

Hi guys, I need to create a tracker to monitor the number of days a task that is still uncompleted. Can someone tell me the formula and give me a sample? Thanks. Thanks.

Answer 1

It's pretty easy actually.

If you have two dates say in cells A2 and B2 for example and you want to find the difference in days between the two and show it in cell C2, you can do it like this:

C2 = B2 - A2

As you can tell the formula is really simple. Just subtract the cells. What confuses most people though is they sometimes will get this really funny answer. If you get a really funny answer, go back to the cell (in this Example C2) and format the cell as a Number format and change the decimal places to 0.

To use today's date, just use the now function. So it would be:

C2 = Now() - A2 using the same example

Answer 2

Hi,
If u have two dates, then simply subtract recent date ( or deadline for the job) from old data (or the current date). U would get the difference between the two.
For this cell where u want to subtract 2 dates, write click on the cell, select "Format Cells...", Select "Number Tab", then in "Category" list select "Number" and in "Decimal Places" change it to zero. Press "OK".
Now in that particular cell simply subtract 2 dates. if u want 2 see delay from today, then use the formula "=Now()-10/08/2007", u would get the difference.