It means that tie entry is a text field, not a date entry.

You could try

=DATE(YEAR(TODAY()),VALUE(RIGHT(B1,LEN(B1)-FIND("/",B1))),LEFT(B1,FIND("/",B
1)-1))

--
HTH

Bob Phillips

"andrewm" wrote in
message ...

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