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

.