Having automatical substraction

Microsoft Ms sla excel lic/sa 2yr-1
April 29, 2010 at 07:38:06
Specs: Windows XP

I try to have excell substract automatically one each day to the numbers I will place in a column.

It should help managing the deadlines of various projects, which are not due to the same date.

Thus I would like to be able to put in one column the number of days left, and that each day one is automatically substracted to this number (which is the logic as each day we are one day closer to the deadline).

I searched on google but couldn't find the answer I was looking for (I found a pseudo-beginning of solution using the NOW function but after searching in this direction, it doesn't seem to be the good path)

See More: Having automatical substraction

Report •

April 29, 2010 at 09:02:06
Why not use the dates to calculate the number of days left?

Assuming the current date is A1, and the "Due" date is A2, All you need to do is subtract the due date from the current date.

A1 =NOW()
A2 12/25/2010
C1 =A2-A1

Which will give you 240 days


Report •

April 29, 2010 at 10:09:46
It would be difficult to directly subtract a value (e.g. 1) from number in another cell on a daily basis.

Somewhere along the way Excel needs to know when the day has changed so that it knows to subtract the value.

I would use the project's end date (or a milestone date) to determine the number of days left.

e.g. With a date in A1, this will tells you how many days are left and it will update each day.


Report •

April 30, 2010 at 00:55:57
Thank you very much!!
You solved my problem!

Report •

Related Solutions

Ask Question