Hi,
I am trying to get help on a formula, I will try and explain what I need.
I have a spreasheet with a list of dates in column A and a list of dates in
column B (dd/mm/yyyy). What I would like is a formula in column C that will
either display Y or N (Y if the date in column A matches the date in column B
if the dates are differnent I would like column C to display N). for example
:-
Column A Column B Column C
10/01/2005 10/01/2005 Y
25/02/2005 28/10/1997 N
Thanks
Linc - 12 Jan 2006 17:16 GMT
In Column C1:
=IF(A1=B1,"Y","N")