View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ward376 ward376 is offline
external usenet poster
 
Posts: 360
Default 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