what is '

[andrewm]

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

 

[Bob Phillips]

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))

 

[Domenic]

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!