I have a spreadsheet whereby in column G the user inputs a date and
column H contains the formula

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

However, I need the user to be able to enter the date in column G as
dd/mm/yyyy OR yyyy

Column H needs to display yyyy

This works fine if the user is only able to enter dd/mm/yyyy in column
G and this column has been set up to recognise the contents as a Date
in that format. However, if the user, for example enters 2008 in
column G, then column H reads 1905 - please help!


--
ajames
------------------------------------------------------------------------
ajames's Profile: http://www.excelforum.com/member.php...o&userid=31502
View this thread: http://www.excelforum.com/showthread...hreadid=514368