#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Autofill

Sorry Mike, I was using the wrong cells. Works fine as posted. Thanks for the
help.

"fretburn" wrote:

Mike,
It seems to not like my format maybe. Here are the results
11/4/2009
11/7/2009
40128

Thanks for trying.

"Mike H" wrote:

Hi,

Enter the first 2 dates manually in A1 & A2 and then this formula in A3

=OFFSET(A3,-2,0)+7

Drag down

Mike

Then

"fretburn" wrote:

Howdy
New here so not sure if this is the right place to post. I searched and read
and didnt find an answer specific to my question. If i missed it please
provide a link to it. How can I autofill dates but only for alternating Wed.
and Sat.?

Thanks in advance

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
Autofill DC Excel Discussion (Misc queries) 1 May 15th 08 02:51 PM
autofill Cdavis Excel Discussion (Misc queries) 4 May 10th 06 10:19 PM
AutoFill autofill Excel Discussion (Misc queries) 1 February 20th 06 08:29 PM
Autofill sisco98 Excel Worksheet Functions 1 June 28th 05 01:30 PM
Autofill: Need to autofill one week block, (5) weekday only into cells. dstock Excel Discussion (Misc queries) 1 June 17th 05 08:21 PM


All times are GMT +1. The time now is 07:13 PM.

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

About Us

"It's about Microsoft Excel"