I have got an excellent array formula from domenic. however the dates
in the spreadsheet have a ' before them.

eg '15/7

1. what is it
2. I am trying to down a row place dates a1, a2 = a1+2, a3 = a2+2
how do you do this with the ' before the date

ta

andrewm


--
andrewm
------------------------------------------------------------------------
andrewm's Profile: http://www.excelforum.com/member.php...o&userid=23130
View this thread: http://www.excelforum.com/showthread...hreadid=389288