software

In a form, I have a Years of service note. It works as it should except for
the first year of work, which would really be quot;0quot; years for the first year.
gt;D48 gt; 02/06/06
gt;D48 is the Anniversary date MM/dd/yy
gt;H48 is the number of years of service
gt;H48 gt;=IF(D48=quot;quot;,quot;quot;,DATEDIF(D48,TODAY(),quot;Yquot;))
How can I get this to show quot;0quot; years for the first year?

Tks


It should show 0 for the first year! Check, tools,options,view the zero
values box should be ticked otherwise 0's do not appear!

Regards

Dav--
Dav
------------------------------------------------------------------------
Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=508020Tks ya'all... I forgot about looking at the options! I kept the original
formula...

Great help! Tks again...

quot;Davquot; wrote:

gt;
gt; It should show 0 for the first year! Check, tools,options,view the zero
gt; values box should be ticked otherwise 0's do not appear!
gt;
gt; Regards
gt;
gt; Dav
gt;
gt;
gt; --
gt; Dav
gt; ------------------------------------------------------------------------
gt; Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
gt; View this thread: www.excelforum.com/showthread...hreadid=508020
gt;
gt;