=(DATE(2007,6,30)-TODAY())/7
--
David Biddulph

"plys" wrote in message
...
Looking for help with a formula that tells me, from the current todays
date,
how many weeks are left in a fiscal year that ends on 6/30/07. With that
information, I should then be able to average hours needed to accomplish
individual goals.

Thx in advance...