T-date countdown

[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.

 

[CyberTaz]

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

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