what is '

A

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
 
B

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

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!
 
Top