View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CMA
 
Posts: n/a
Default 1-2-3 @ function to Excel Assistance


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