Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
dstock
 
Posts: n/a
Default Autofill: Need to autofill one week block, (5) weekday only into cells.


What I need to do I'm sure is simple but I can't get the formula/format
correct. What I want to do is be able to autofill weekday only, one
week blocks at a time. For example, I would like to be able to enter
6/20/05 - 6/24/05, select the cell and then drag it to x amount of cells
to have it autofill the same format. So 4 cells would look like this:

6/20/05-6/24/05
6/27/05-7/1/05
7/4/05-7/8/05
7/11/05-7/15/05

Non-business weekdays aren't a problem, I just need the 5 day, weekday,
one week blocks to be able to autofill. Any help is appreciated, thanks.


--
dstock
------------------------------------------------------------------------
dstock's Profile: http://www.excelforum.com/member.php...o&userid=24225
View this thread: http://www.excelforum.com/showthread...hreadid=380192

  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

How about using a couple of columns?

I put this in A1:
6/20/2005
I put this in A2:
=a1+7

I put this in B1:
=TEXT(A1,"mm/dd/yy")&"-"&TEXT(A1+4,"mm/dd/yy")
And dragged down to B2.

Then I selected A2:B2 and dragged down as far as I wanted.

Then I could select column B and
edit|copy
edit|paste special|Values
and
delete column A
(if I wanted.)

(Actually, I think I'd just hide column A so I could use it later.)

dstock wrote:

What I need to do I'm sure is simple but I can't get the formula/format
correct. What I want to do is be able to autofill weekday only, one
week blocks at a time. For example, I would like to be able to enter
6/20/05 - 6/24/05, select the cell and then drag it to x amount of cells
to have it autofill the same format. So 4 cells would look like this:

6/20/05-6/24/05
6/27/05-7/1/05
7/4/05-7/8/05
7/11/05-7/15/05

Non-business weekdays aren't a problem, I just need the 5 day, weekday,
one week blocks to be able to autofill. Any help is appreciated, thanks.

--
dstock
------------------------------------------------------------------------
dstock's Profile: http://www.excelforum.com/member.php...o&userid=24225
View this thread: http://www.excelforum.com/showthread...hreadid=380192


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
user defined function Brian Rogge Excel Worksheet Functions 5 May 23rd 05 06:21 PM
INDIRECT Function and Autofill Neil Grantham Excel Worksheet Functions 1 April 21st 05 12:22 AM
Line or bar graphs for tracking stocks profit and loss. Mocity Charts and Charting in Excel 1 January 21st 05 02:21 AM
I need week number in excell from a date, first week must be mini. jPeich Excel Discussion (Misc queries) 4 January 5th 05 02:21 AM
first week of year - according to european standard soren Excel Worksheet Functions 3 November 2nd 04 08:21 PM


All times are GMT +1. The time now is 12:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"