Does Mon 17 stand for 8/17/2009?

If so, you can just enter the actual date 8/17/2009 and fill down as needed.
Then custom format as ddd d.

--
Biff
Microsoft Excel MVP


"Bleau" wrote in message
...
Hi Folks

I need to enter

Mon 17
Tues 18
Wed 19 etc

When using the fill handle, it will only change 17 to 18 to 19 or Mon to
Tues to Wed.

I need to change BOTH so Mon 17 becomes Tues 18 and Wed 19 etc.,

Any ideas pepes? Apologies if this has already been raised but I couldn't
find any previous postings.