Hi....

I'm not a newby to EXCEL but I'm having problems with my Cell fill...

I have a cell that is ex.:

Saturday, July 29, 2007

Everytime I try to extend the fill series...it does this fill:

Saturday, July 29, 2008
Saturday, July 29, 2009 ....and so on....

What I want isL:

Sunday, July 30, 2007
Monday, July 31, 2007 ....and so on....

Can anyone shed any light on my fudderery???? I would appreciate any help.

--
Thanx, Suz

Set the first two cells to the desired dates , select them both and fill down.

"Suzanne" wrote:

Hi....

I'm not a newby to EXCEL but I'm having problems with my Cell fill...

I have a cell that is ex.:

Saturday, July 29, 2007

Everytime I try to extend the fill series...it does this fill:

Saturday, July 29, 2008
Saturday, July 29, 2009 ....and so on....

What I want isL:

Sunday, July 30, 2007
Monday, July 31, 2007 ....and so on....

Can anyone shed any light on my fudderery???? I would appreciate any help.

--
Thanx, Suz

That's a workaround Toppers but.................

You should be able to fill series by dragging July 29, 2008 alone.

Don't understand why Excel changes the year unless July 29, 2007 is text to
start with.

In that case the 2007 would change to 2008 and so on.

Try Selecting the "date" and DataText to ColumnsDelimitedFinish

Or DataText to ColumnsNextNextColumn Data FormatDateMDYFinish.


Gord Dibben MS Excel MVP


On Mon, 23 Jul 2007 14:40:07 -0700, Toppers
wrote:

Set the first two cells to the desired dates , select them both and fill down.

"Suzanne" wrote:

Hi....

I'm not a newby to EXCEL but I'm having problems with my Cell fill...

I have a cell that is ex.:

Saturday, July 29, 2007

Everytime I try to extend the fill series...it does this fill:

Saturday, July 29, 2008
Saturday, July 29, 2009 ....and so on....

What I want isL:

Sunday, July 30, 2007
Monday, July 31, 2007 ....and so on....

Can anyone shed any light on my fudderery???? I would appreciate any help.

--
Thanx, Suz

Hi...Toppers and Gord....

Well....I tried both of your suggestions....and neither works. I made sure
my column was set to date and delimited. Any other hints???

--
Thanx, Suz


"Suzanne" wrote:

Hi....

I'm not a newby to EXCEL but I'm having problems with my Cell fill...

I have a cell that is ex.:

Saturday, July 29, 2007

Everytime I try to extend the fill series...it does this fill:

Saturday, July 29, 2008
Saturday, July 29, 2009 ....and so on....

What I want isL:

Sunday, July 30, 2007
Monday, July 31, 2007 ....and so on....

Can anyone shed any light on my fudderery???? I would appreciate any help.

--
Thanx, Suz

Just formatting a text date to date will not do the trick. You have to force it
to become a number which is how Excel stores dates.

IMO you have a date July 29, 2007 that is text.

I am surprised the Text to Columns did not do the trick.

Try this................format to General.

Copy an empty cell.

Select the cell with the date and editpaste specialaddokesc.

Re-format to date.

Now try your fill series.


Gord


On Mon, 23 Jul 2007 18:44:00 -0700, Suzanne
wrote:

Hi...Toppers and Gord....

Well....I tried both of your suggestions....and neither works. I made sure
my column was set to date and delimited. Any other hints???

Good morning...Gord....

ACKKK!!! I cannot figure this one out....I tried everything you suggested
and the fill series still wants to keep everything the same but change the
year....is it because
I have the day of the week?????

Tuesday, July 24, 2007
the next becomes
Tuesday, July 24, 2008 ....and so on....

I just want it to become the next day as in:
Wednesday, July 25, 2007

I am just perplexed!

I will listen to anything you can come up with....

Thanx again,

Suzanne
--
Thanx, Suz


"Gord Dibben" wrote:

Just formatting a text date to date will not do the trick. You have to force it
to become a number which is how Excel stores dates.

IMO you have a date July 29, 2007 that is text.

I am surprised the Text to Columns did not do the trick.

Try this................format to General.

Copy an empty cell.

Select the cell with the date and editpaste specialaddokesc.

Re-format to date.

Now try your fill series.


Gord


On Mon, 23 Jul 2007 18:44:00 -0700, Suzanne
wrote:

Hi...Toppers and Gord....

Well....I tried both of your suggestions....and neither works. I made sure
my column was set to date and delimited. Any other hints???

It's because the dates are text, text values with numbers in them will fill
the number part at the end which it does since the year changes. Do you
type these in? If so the date format is wrong.
It's best to enter a date like

07/24/07

then use a custom format of

dddd, mmmm dd, yyyy

then copy down and it will change the way you want, I doubt you can ever
type in

Tuesday, July 24, 2007

and get Excel to recognize it as a date


--
Regards,

Peo Sjoblom



"Suzanne" wrote in message
...
Good morning...Gord....

ACKKK!!! I cannot figure this one out....I tried everything you suggested
and the fill series still wants to keep everything the same but change the
year....is it because
I have the day of the week?????

Tuesday, July 24, 2007
the next becomes
Tuesday, July 24, 2008 ....and so on....

I just want it to become the next day as in:
Wednesday, July 25, 2007

I am just perplexed!

I will listen to anything you can come up with....

Thanx again,

Suzanne
--
Thanx, Suz


"Gord Dibben" wrote:

Just formatting a text date to date will not do the trick. You have to
force it
to become a number which is how Excel stores dates.

IMO you have a date July 29, 2007 that is text.

I am surprised the Text to Columns did not do the trick.

Try this................format to General.

Copy an empty cell.

Select the cell with the date and editpaste specialaddokesc.

Re-format to date.

Now try your fill series.


Gord


On Mon, 23 Jul 2007 18:44:00 -0700, Suzanne

wrote:

Hi...Toppers and Gord....

Well....I tried both of your suggestions....and neither works. I made
sure
my column was set to date and delimited. Any other hints???

Suzanne wrote:
Good morning...Gord....

ACKKK!!! I cannot figure this one out....I tried everything you suggested
and the fill series still wants to keep everything the same but change the
year....is it because
I have the day of the week?????

Tuesday, July 24, 2007
the next becomes
Tuesday, July 24, 2008 ....and so on....

I just want it to become the next day as in:
Wednesday, July 25, 2007

I am just perplexed!

I will listen to anything you can come up with....

Thanx again,

Suzanne

Suzanne,

If you format cells with the date (use format"dddd, mmmm d, yyyy", and
put in 7/24/07, you should see "Tuesday, July 24, 2007". Yes? But if you
type in General format "Tuesday, July 24, 2007" it comes out as text.
and the year indexes as you fill the series. Do it the first way, and
the day indexes as you fill it. That's how it works for me, anyways...

Beege

OMG

THANK YOU ....ALL for your help....duh...duh...duh...I finally got it! It's
beautiful!

Thank you, Toppers, Gord, Peo and Beege.....yeah yeah yeahhhhh!

Suzanne
--
Thanx, Suz


"Beege" wrote:

Suzanne wrote:
Good morning...Gord....

ACKKK!!! I cannot figure this one out....I tried everything you suggested
and the fill series still wants to keep everything the same but change the
year....is it because
I have the day of the week?????

Tuesday, July 24, 2007
the next becomes
Tuesday, July 24, 2008 ....and so on....

I just want it to become the next day as in:
Wednesday, July 25, 2007

I am just perplexed!

I will listen to anything you can come up with....

Thanx again,

Suzanne

Suzanne,

If you format cells with the date (use format"dddd, mmmm d, yyyy", and
put in 7/24/07, you should see "Tuesday, July 24, 2007". Yes? But if you
type in General format "Tuesday, July 24, 2007" it comes out as text.
and the year indexes as you fill the series. Do it the first way, and
the day indexes as you fill it. That's how it works for me, anyways...

Beege