View Single Post
  #2   Report Post  
Cutter
 
Posts: n/a
Default


Good morning Ltat42a

For #1 do this:

=IF(B2="","",B2)

For #2 do this:

=TRUNC(DATEDIF(A7,TODAY(),"m")/12)


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=466602