View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Ricter Ricter is offline
external usenet poster
 
Posts: 14
Default Can I count down days till an event?

Where cell A1 contains your end date:

The "count down" cell contains:

=Datedif(Today(), A1, "D")



"Michael" wrote:

I have a begining date in one cell, an ending date in another cell and
would like to put the number of days left in another cell.

Can you help me out?

I thought there might be a way to update todays date each time I
opened the document and that cell would be formated to give the total
of days left but I am lost.

Thanks in advance

Peace

Michael