Counting Down from a certain date

B

Benjii

Hi,
I need to countdown the amount of days from a future date to today (the day
that I open my excel spreadsheet). The Future date for example is 20th August
2007. Does anyone know how I can have it set-up so that when I open excel it
will continue counting down the amount of days from the 20th August to the
day i open the file. ie. 20th August to today (10th April) may be 125 days,
but when I open excel tomorrow (11th April) it will say 124 days.
Is this possible?
Thanks...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Complicated Date Calculation needed 5
counting down dates 1
Max/Min per item from a changing list 0
How can I recover a file from word 2007 when it says - "ilegalqualified name character" when I try a 4
formulas to count dates 2
Creating a Report for a certain Resource and a certain Date 3
Format Date Filter Problem 1
Date/Day VBA Calculation 4

Top