Reply to thread

Message: [QUOTE="Bernard Liengme, post: 3234382"] It is not helpful having the top row with text such as 6/29/09 - 7/12/09 I just used the start dates in A1:D1 29-Jun-09 13-Jul-09 27-Jul-09 10-Aug-09 15-Jul-09My 'calculated date' of 15/July/2009 is in G1 In A2 I have the formula =IF(AND($G$1>=A1,$G$1<B1),$G$1,"") This is copied across to D2 I had to format row 2 as dates otherwise I got a value of 40009 in B2 If you want both start and end dates then place them in two rows 29-Jun-09 13-Jul-09 27-Jul-09 10-Aug-09 12-Jul-09 26-Jul-09 9-Aug-09 23-Aug-09 15-Jul-09Now my formula in A3 is =IF(AND($G$1>=A1,$G$1<=A2),$G$1,"") best wishes [/QUOTE]