Dates-Conversion
This does what your original post asks - returns the value from b3 if
a1 is equal to b2.
=IF(A1-(VALUE(TEXT(B2,"yyyy")))=0,B3,"They're different.")
Or you can convert the value in column a to a date and go from the
=VALUE("1/1/"&A2)
Cliff Edwards
|