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