Countdown from Entered Date
 

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?
--
Thanks As Always
Rip

Countdown from Entered Date
 

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


"Ripper" wrote in message
...
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?
--
Thanks As Always
Rip

Countdown from Entered Date
 

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" wrote:

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


"Ripper" wrote in message
...
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?
--
Thanks As Always
Rip

Countdown from Entered Date
 

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" wrote in message
...
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" wrote:

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


"Ripper" wrote in message
...
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?
--
Thanks As Always
Rip

Countdown from Entered Date
 

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


On Tue, 1 Sep 2009 08:24:01 -0700, Ripper
wrote:

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?