Convert real time to a % in Excel

B

Barry

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
 
B

Bob Phillips

=(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)
 
Top