sg2209
12-27-2018, 08:17 AM
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
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