T-date countdown

E

exhibition

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

Hello:

We run an annual conference and would like Excel to tell us how many weeks remain until the event. This year it takes place between March 10-14 2010. We are "x" weeks away from the date? Is there a formula for this?

Thanks.
 
C

CyberTaz

One option -- although someone may offer something more elegant:

=("3/10/2010"-TODAY())/7
 
Top