Thread: Date Series
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Date Series

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.