View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Ripper Ripper is offline
external usenet poster
 
Posts: 25
Default 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