If Formula with Year Function

[sg2209]

hi Friends,

i am struggling with the below formula not sure why not getting the results

i need if Cell C2 has a date then year would populate in A2 else blank i have tried the below formula

=IF(C2=""," ","=YEAR(C2))")i am getting = Year(C2))") in results, Kindly help me with this

[Moragtao]

Use this instead:

=IF(C2=""," ", YEAR(C2))

[sg2209]

thank you so much
and what of i need to use this same as function via vba