Fill Series

[Suzanne]

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.

 

[Toppers]

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

 

[Gord Dibben]

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 Data>Text to Columns>Delimited>Finish

Or Data>Text to Columns>Next>Next>Column Data Format>Date>MDY>Finish.


Gord Dibben MS Excel MVP

 

[Suzanne]

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???

 

[Gord Dibben]

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 edit>paste special>add>ok>esc.

Re-format to date.

Now try your fill series.


Gord

 

[Suzanne]

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

 

[Peo Sjoblom]

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

 

[Beege]

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

 

[Suzanne]

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