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?