I sent the file attach because my English is not good.
but ok, I will try.
I have a sheet that counts how long each worker is in the company.
a cell "B2" is formatted in date with the function =Now().
another cell "C4" has the admission date, each worker's time is counted
in "E4" with =(B2-C4)/365.
B2=07-Aug-2007
C4=02-Jul-1990
this gives the result of 16 years and eleven parts of 365 days.
I intend to obtain this result in Y/M/D.
the sheet has in the same row other cell "D4" with the ending date.
this cell is always blank until an employee finish with us.
I would like that cell when filled out the time of work "(B2-C4)/365"
stopped counting, and at the same time all of the cells of the same Row
turn red, except the cell E4.
Thanks Pete
Joćo
--
Dipwind
------------------------------------------------------------------------
Dipwind's Profile:
http://www.excelforum.com/member.php...o&userid=36276
View this thread:
http://www.excelforum.com/showthread...hreadid=568990