Countdown from Entered Date

  • Thread starter Thread starter Ripper
  • Start date Start date
R

Ripper

I need to write a formula that will countdown from 60 from a date that is
entered by the user. How do I do that?
 
Rip,

Countdown from 60, or countdown to 60 days from a date, or 60 days to a date, or....


Perhaps,

=ABS(TODAY()-A1)

with the date in A1 - the formula will return the number of days until or after the date in A1....

HTH,
Bernie
MS Excel MVP
 
Thanks for responding..

Once we create a record by entering a date, we have 60 days to complete the
next task. What I need is a cell that will tell us how many of the origional
60 days we have left to complete step 2.
--
Thanks As Always
Rip


Bernie Deitrick said:
Rip,

Countdown from 60, or countdown to 60 days from a date, or 60 days to a date, or....


Perhaps,

=ABS(TODAY()-A1)

with the date in A1 - the formula will return the number of days until or after the date in A1....

HTH,
Bernie
MS Excel MVP
Click to expand...
 
Ripper,

Try

=A1 - TODAY() + 60

though you should check to see if that suits exactly what you want - perhaps 60 or 61 or 59,
depending on your counting conventions.

HTH,
Bernie
MS Excel MVP


Ripper said:
Thanks for responding..

Once we create a record by entering a date, we have 60 days to complete the
next task. What I need is a cell that will tell us how many of the origional
60 days we have left to complete step 2.
Click to expand...
 
Enter date in A1..............October 31, 2009

In A2 enter =A1-TODAY() & " Days to go"

Each day you open the workbook, the number in A2 will be one less.


Gord Dibben MS Excel MVP
 
Back
Top