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

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

Hi Andrew,

As Bob has explained, the ' means that the value is a text value, not a
true date value. For some reason, don't ask me why, I entered the dates
as such in my working example which was not intended for you. :)
Ignore that and enter your dates in the proper format. Then you'll be
able to do...

=A1+1

...and so on. Or, enter your starting date in A1, place your cursor
over the lower right corner, the cursor will change, click and drag
down.

Hope this helps!

andrewm Wrote:
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


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