help with dates please
 

hello

I have a date in A1 which is a 'start date', 01/02/10

In A2 I have the same date formatted as Mon 01/02/10 using Text(A1,"ddd
dd/mm/yy") . no problem

In A3, A4 etc I need Tue 02/02/10, Wed 03/02/10 etc etc etc. ie the dates
are incrementing by 1 day in each row.

Normally I would just add 1 to the date above, but the text formula makes
this impossible.

help & advice please ??

Thanks as always

KK

help with dates please
 

Is there a reason you can't just format a2

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KRK" wrote in message
...
hello

I have a date in A1 which is a 'start date', 01/02/10

In A2 I have the same date formatted as Mon 01/02/10 using Text(A1,"ddd
dd/mm/yy") . no problem

In A3, A4 etc I need Tue 02/02/10, Wed 03/02/10 etc etc etc. ie the
dates are incrementing by 1 day in each row.

Normally I would just add 1 to the date above, but the text formula makes
this impossible.

help & advice please ??

Thanks as always

KK

help with dates please
 

Format date as date - any standard at first - ok
Format date again but this time select custom and make it
dddd-dd-mm-yy
ok

--
Russell Dawson
Excel Student


"KRK" wrote:

hello

I have a date in A1 which is a 'start date', 01/02/10

In A2 I have the same date formatted as Mon 01/02/10 using Text(A1,"ddd
dd/mm/yy") . no problem

In A3, A4 etc I need Tue 02/02/10, Wed 03/02/10 etc etc etc. ie the dates
are incrementing by 1 day in each row.

Normally I would just add 1 to the date above, but the text formula makes
this impossible.

help & advice please ??

Thanks as always

KK

.

help with dates please
 

Error in last post

It should be

dddd-dd-mmm-yy
--
Russell Dawson
Excel Student


"KRK" wrote:

hello

I have a date in A1 which is a 'start date', 01/02/10

In A2 I have the same date formatted as Mon 01/02/10 using Text(A1,"ddd
dd/mm/yy") . no problem

In A3, A4 etc I need Tue 02/02/10, Wed 03/02/10 etc etc etc. ie the dates
are incrementing by 1 day in each row.

Normally I would just add 1 to the date above, but the text formula makes
this impossible.

help & advice please ??

Thanks as always

KK

.

help with dates please
 

No I was right first time - duuuhhh !
--
Russell Dawson
Excel Student


"Russell Dawson" wrote:

Format date as date - any standard at first - ok
Format date again but this time select custom and make it
dddd-dd-mm-yy
ok

--
Russell Dawson
Excel Student


"KRK" wrote:

hello

I have a date in A1 which is a 'start date', 01/02/10

In A2 I have the same date formatted as Mon 01/02/10 using Text(A1,"ddd
dd/mm/yy") . no problem

In A3, A4 etc I need Tue 02/02/10, Wed 03/02/10 etc etc etc. ie the dates
are incrementing by 1 day in each row.

Normally I would just add 1 to the date above, but the text formula makes
this impossible.

help & advice please ??

Thanks as always

KK

.

help with dates please
 

Try it like this...

A1 = some date

Entered in A2 and copied down as needed:

=TEXT(A$1+ROWS(A$2:A2)-1,"ddd dd/mm/yy")

--
Biff
Microsoft Excel MVP


"KRK" wrote in message
...
hello

I have a date in A1 which is a 'start date', 01/02/10

In A2 I have the same date formatted as Mon 01/02/10 using Text(A1,"ddd
dd/mm/yy") . no problem

In A3, A4 etc I need Tue 02/02/10, Wed 03/02/10 etc etc etc. ie the
dates are incrementing by 1 day in each row.

Normally I would just add 1 to the date above, but the text formula makes
this impossible.

help & advice please ??

Thanks as always

KK

help with dates please
 

It's my learning curve! And now, I've learnt something new!
I was under the impression that you had to format as date first - but no.

Thanks Don
--
Russell Dawson
Excel Student


"Don Guillett" wrote:

Is there a reason you can't just format a2

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"KRK" wrote in message
...
hello

I have a date in A1 which is a 'start date', 01/02/10

In A2 I have the same date formatted as Mon 01/02/10 using Text(A1,"ddd
dd/mm/yy") . no problem

In A3, A4 etc I need Tue 02/02/10, Wed 03/02/10 etc etc etc. ie the
dates are incrementing by 1 day in each row.

Normally I would just add 1 to the date above, but the text formula makes
this impossible.

help & advice please ??

Thanks as always

KK

.

help with dates please - Thanks
 

Hello & thanks, I've got it now.

My understanding of cell formats is very poor and I'd been using the text()
function as an alternative, tho I see it actually does the same thing..

Thanks again

KK


"KRK" wrote in message
...
hello

I have a date in A1 which is a 'start date', 01/02/10

In A2 I have the same date formatted as Mon 01/02/10 using Text(A1,"ddd
dd/mm/yy") . no problem

In A3, A4 etc I need Tue 02/02/10, Wed 03/02/10 etc etc etc. ie the
dates are incrementing by 1 day in each row.

Normally I would just add 1 to the date above, but the text formula makes
this impossible.

help & advice please ??

Thanks as always

KK

help with dates please
 

Sat, 13 Feb 2010 12:27:54 -0000 from KRK
:

hello

I have a date in A1 which is a 'start date', 01/02/10

In A2 I have the same date formatted as Mon 01/02/10 using Text(A1,"ddd
dd/mm/yy") . no problem

In A3, A4 etc I need Tue 02/02/10, Wed 03/02/10 etc etc etc. ie the dates
are incrementing by 1 day in each row.

Normally I would just add 1 to the date above, but the text formula makes
this impossible.

How so?

=Text(1+A1,"ddd dd/mm/yy")
=Text(2+A1,"ddd dd/mm/yy")

and so forth.

Or, if you want something you can click and drag,

=Text(row()-1+A1,"ddd dd/mm/yy")


--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com
Shikata ga nai...