Auto Create Weekly Date Range Base On a Date

[Kintantay]

In column A I have dates 08/01/2011 to 11/30/2011. Is there a formula that will look at the date in cell and return a date range in column B. Eg. Column A has
A1 08/01/2011
A2 08/10/2011
A3 08/22/2011
Column B should return
B1 08/01/2011 – 08/05/2011
B2 08/08/2011 – 08/12/2011
B3 08/22/2011 - 08/26/2011

Is this possible?

Thanks in advance

Kin

 

[jim may]

Like so?

Excel Workbook
	A	B
1	8/1/2011	08/01/2011 - 08/05/2011
2	8/10/2011	08/10/2011 - 08/14/2011
3	8/22/2011	08/22/2011 - 08/26/2011
Sheet1

Excel 2007

Cell Formulas
Range	Formula
B1	=TEXT(A1,"mm/dd/yyyy")& " - " & TEXT(A1+4,"mm/dd/yyyy")

 

[Kintantay]

Thanks for your timely response. I entered the formula and it worked however it doesnt give the same affect for other dates within that range. I'm trying to achieve this:

8/1/2011 08/01/2011 - 08/05/2011
8/2/2011 08/01/2011 - 08/05/2011
8/9/2011 08/08/2011 - 08/12/2011
8/10/2011 08/08/2011 - 08/12/2011
8/15/2011 08/15/2011 - 08/19/2011
8/16/2011 08/15/2011 - 08/19/2011
8/17/2011 08/15/2011 - 08/19/2011

 

[T. Valko]

Thanks for your timely response. I entered the formula and it worked however it doesnt give the same affect for other dates within that range. I'm trying to achieve this:

8/1/2011 08/01/2011 - 08/05/2011
8/2/2011 08/01/2011 - 08/05/2011
8/9/2011 08/08/2011 - 08/12/2011
8/10/2011 08/08/2011 - 08/12/2011
8/15/2011 08/15/2011 - 08/19/2011
8/16/2011 08/15/2011 - 08/19/2011
8/17/2011 08/15/2011 - 08/19/2011

Will the dates in column A always be weekday (Monday thru Friday) dates?

What day does your week start? Is it Monday or Sunday?

 

[Kintantay]

The dates in column a will always be a weekday. Crazy as it sounds, the week begins on Saturday and end on a Friday. I didnt want to cause any confusion so I elected to omit that bit of information.

 

[T. Valko]

The dates in column a will always be a weekday. Crazy as it sounds, the week begins on Saturday and end on a Friday. I didnt want to cause any confusion so I elected to omit that bit of information.

Try this...

=TEXT(A1-WEEKDAY(A1,2)+1,"m/d/yyyy")&" - "&TEXT(A1-WEEKDAY(A1,2)+5,"m/d/yyyy")

 

[Kintantay]

Thank you. I will give it a try and let you know the results. Thanks again. t

 

[jim may]

"I didnt want to cause any confusion so I elected to omit that bit of information."

probably not a good practice. JMay

 

[Kintantay]

The solution worked fine. Thanks to everyone.

Kin

 

[T. Valko]

The solution worked fine. Thanks to everyone.

Kin

You're welcome. Thanks for the feedback!