ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Weeks left in a Fiscal year (https://www.excelbanter.com/excel-discussion-misc-queries/120013-weeks-left-fiscal-year.html)

plys

Weeks left in a Fiscal year
 
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...

David Biddulph

Weeks left in a Fiscal year
 
=(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...





All times are GMT +1. The time now is 08:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com