How to fill down weekend dates

[Chrissya03]

I am putting together a weekend on-call schedule for work. I need each row to show the weekend dates for 2011. For example, Row 1 would say 1/1/2011-1/2/2011, row 2 should say 1/8/2011-1/9/2011, so on and so forth. I cannot get it to auto fill that way, so is there a formula I should use instead?

 

[Ruddles]

Simplest suggestion: keep the Saturday and Sunday dates in separate columns, then you can just add 7 to them to get the following weekend's dates.

 

[MickG]

Hi, Place the first 2 dates in "A1 & A2", Place formula as shown in "B3" in "A3" then Drag down.

[COLOR="RoyalBlue"][B]Row No [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(A)     [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(B)               [/B][/COLOR] [COLOR="RoyalBlue"][B]Col(C) [/B][/COLOR]
1.      01/01/2011                               
2.      02/01/2011                               
3.      08/01/2011  =(OFFSET(A3,-2,0))+7

Regards Mick

 

[Ruddles]

Or, assuming your first date-range is in A1 (like 01/01/2010-01/02/2010), put the following in A2:-

=TEXT(DATEVALUE(LEFT(A1,FIND("-",A1)-1))+7,"mm/dd/yyyy")&"-"&TEXT(DATEVALUE(MID(A1,FIND("-",A1)+1,10))+7,"mm/dd/yyyy")

That should copy down.

 

[Dave Patton]

With Jan 1, 2011 in A1

C1 for example =TEXT($A$1+(ROW()-1)*7,"mm-dd-yyyy")&" - "&TEXT($A$1+1+(ROW()-1)*7,"mm-dd-yyyy")

Drag or copy down

Format the date to your preference.