Display Week Ranges

[txsteve]

I'm a rookie and looking for a simple way to display week date ranges as shown in the attachment for a year at a time.

[txsteve]

Another words D1, E1, F1, G1, H1 and so on would populate with the Mon-Fri dates of each successive week.

[shg]

Use separate rows for the Monday and Friday dates; enter two consecutive Mondays, select both cells, and drag across.

[txsteve]

Thank you for the suggestion.

Drag is a nice feature, but I need something a little more advanced.

I don't need to display weekends, only the (Mon-Fri) work weeks.

See updated image.

[shg]

I don't know what you want that my suggestion doesn't address. You might post a workbook instead of pictures.

[txsteve]

Here is the attached sample file.

What I need is for B1 to display the first work days of the new year (Thursday and Friday) as shown.

Then,
C1 = (Mon)1/5/09, C2 = (Fri)1/9/09.
D1 = (Mon)1/12/09, D2 = (Fri) 1/16/09
E1 = (Mon)1/19/09, E2 = (Fri) 1/23/09

and so on...for the entire 2009 year.

[Ron Coderre]

With
A1 containing a date.....eg 1/1/2009

This formula returns the 1st Mon thru Fri range that includes that date:

Please Login or Register  to view this content.

Copy that formula across as far as you need.

In the above example, the formulas return:

Please Login or Register  to view this content.

Is that something you can work with?

[shg]

C1: = B1 + 7 - WEEKDAY(B1, 3)

D1 and copy across: =C1+7

C2 and copy across: =B2+7

[txsteve]

The "1" row is working great. THANK YOU!!!!

Not sure what I am doing wrong on the second row. (See attachment) It keeps returning a Monday value.

[shg]

You're not using the formula I suggested in C2 (or D1 for that matter).

[txsteve]

Got it.

Sorry, being a rookie I was not sure what the other fields were telling me. I copied them as you typed and it is working very well. Thank you.

[shg]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save