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
|