One way to get it done, Bleau
In the startcell, say in B2, enter the full date, ie: 17 Aug 2009
Format B2 as custom: ddd dd
Now you can drag B2 to fill it down, and it'll return exactly what you seek
Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Bleau" wrote:
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.