[dba-Tech] FW: Excel AutoFill question

Scott Marcus marcus at tsstech.com
Thu Apr 19 11:43:08 CDT 2007


It appears in the lower right corner of the fill after you drag the fill
handle. Select 'Fill Weekdays' and you get exactly what you want.

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of Susan
Harkins
Sent: Thursday, April 19, 2007 12:27 PM
To: dba-tech at databaseadvisors.com
Subject: [dba-Tech] FW: Excel AutoFill question

Should've asked where is AutoFill Options -- I've read about it in Help,
I
just can't find it. 
 
Susan H. 

 
I need to fill a range with consecutive dates for just weekdays --
Monday
through Friday. I tried entering the dates for one full week, skipping
the
date for Saturday and Sunday and then entering the date for the
following
Monday -- so six dates, Mon, Tues, Wed, Thur, Fri, next Mon... and then
use
the Autofill handle, but it didn't work. 
 
Any ideas -- seems like this should be easy for Excel. 
 
Susan H. 
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com
  
----------------------------------------------------------------------------TSS Technologies 
NOTICE:  This electronic mail transmission is for the use of the named individual or entity to which it is directed and may contain information that is privileged or confidential.  If you are not the intended recipient, any disclosure, copying, distribution or use of the contents of any information contained herein is prohibited.  If you have received this electronic mail transmission in error, delete it from your system without copying or forwarding it, and notify the sender of the error by replying via email or calling TSS Technologies at (513) 772-7000, so that our address record can be corrected.  
Any information included in this email is provided on an “as is” and “where as” basis, and TSS Technologies makes no representations or warranties of any kind with respect to the completeness or accuracy of the information contained in this email. 




More information about the dba-Tech mailing list