well I need that: in column C shouldnt matter in which cell date is written, if the date in column C is between dates in col. A and B it should check that
( for example : In cell A3 and in cell B3 dates are written- 21/05/2006 in A3 and 24/05/2006 in cell B3 and in cell C1 date is written -22/05/2006
Now I need column D to say "true" or "false" if date in C is in that range
Now if date in C1 is between A3 and B3 should say "true" else "false"
and so on, It shouldnt matter in which cell in C column date is it should find every date in columns A and B that coresponds to date in C column
thnx for ideas