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.