Franz,

The formula works in the perfection, it counts the days and it stops
counting when the ending dates is written.

But in the cell years of service when D4 is filled out returns #NAME!.


what should I make for the result be the difference between D4-C4?

many thanks
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