Convert real time to a % in Excel

I want to create a formula that calculates the time gone in a year as a %
which updates automatically when the spreadsheet is opened. For example the
end of July would be 58.45% time gone

=(A1-DATE(YEAR(A1),1,0))/(DATE(YEAR(A1)+1,1,0)-DATE(YEAR(A1),1,0))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Barry" <Barry@discussions.microsoft.com> wrote in message
news:B4A954CE-D148-459E-B58B-5C0B47E6404B@microsoft.com...
> I want to create a formula that calculates the time gone in a year as a %
> which updates automatically when the spreadsheet is opened. For example
the
> end of July would be 58.45% time gone