Hello, 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)

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.

IE

A1 =NOW()

A2 12/25/2010

C1 =A2-A1Which will give you 240 days

id10t

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.

=A1-TODAY()

Thank you very much!!

You solved my problem!

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History