IF(G10,YEAR(G1),"")

Excel uses the Windows date convention (day 1 = Jan 1, 1900, Day 2 =
Jan 2 1900, ... today (Feb 19, 2006) = 38768.

Try making the "IF(G10,YEAR(G1),"")" into

IF(G130000,YEAR(G1),G1)


--
weavtennis
------------------------------------------------------------------------
weavtennis's Profile: http://www.excelforum.com/member.php...fo&userid=3634
View this thread: http://www.excelforum.com/showthread...hreadid=514368