T
Trevor Aiston
I have a spreadsheet which contains a comumn (C) headed REFERALRECEIVED,
which contains a list of dates un UK dd/mm/yyyy format.
I want to indicated in column N the financial year that data represnts (data
only covers two calander years) so have =IF(C2<="31/03/2009","0809","0910")
what I get is 0809 regardless of date in C column (e.g 24/08/2009). If I
remove the "" from C2<=31/03/2009 I get 2009 regardless of date?
What am i doing wrong
which contains a list of dates un UK dd/mm/yyyy format.
I want to indicated in column N the financial year that data represnts (data
only covers two calander years) so have =IF(C2<="31/03/2009","0809","0910")
what I get is 0809 regardless of date in C column (e.g 24/08/2009). If I
remove the "" from C2<=31/03/2009 I get 2009 regardless of date?
What am i doing wrong