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
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" <[email protected]> wrote in message
news:[email protected]...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks