Coworker just converted a 1-2-3 spreadsheet into Excel workbook. Only
thing that didn't convert was the 1-2-3 @ function for the date.
I need to show the percentage of the year that has elasped from the
start date of 10/01/05 to a date that I provide = % of year elasped.
The 1-2-3 formula for this was:
@DAYS(@DATE(2005,10,1),@DATEVALUE(+H3),3)/365.
I'm a new user so detailed instruction would be helpful. I don't know
if everything goes in one column as in 1-2-3 or if it has to go into
multiple columms.
Thanks in advance
--
CMA
------------------------------------------------------------------------
CMA's Profile:
http://www.excelforum.com/member.php...o&userid=32522
View this thread:
http://www.excelforum.com/showthread...hreadid=523055