Days to go =DATE(YEAR(TODAY())+(MONTH(TODAY())8)*1,8,31)-TODAY()+1
Days gone =DATE(YEAR(TODAY())+(MONTH(TODAY())8)*1,8,31)-TODAY()

--
HTH

Bob Phillips

"baz" wrote in message
...
Please post response and email used here is bogus to prevent spam.
Thanks.

I am trying to create a formula for a fiscal year showing %time passed
and %time left.
The fiscal begins on 9/1/2004 and ends on 8/31/2005.
Everyday the sheet will be opened with the days date showing.
I want to also show the % time passed and % time remaining as stated
earlier.

Thanks in advance for your help.
baz