If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 . |
#4
|
|||
|
|||
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 . |
#5
|
|||
|
|||
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 . |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 . |
#8
|
|||
|
|||
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 |
#9
|
|||
|
|||
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... |
Thread Tools | |
Display Modes | |
|
|