Calculating weeks

[Steve]

Hi

I'm hoping this is more straightforward than I'm making it.

What I want is a formula to look at cell A1 (month) and B1 (year), and
give me the first complete week (ending on a Monday) in that month,
and a second formula to give me the last complete week (ending on a
Monday) in that month. So:

A1 B1
November 2011

result: First 07.11.11; Last: 28.11.11

Any ideas would be greatly appreciated.

Alan

 

[Steve]

Hi Ron

Thank you for replying.

The dates would be used to calculate the number of weeks between start
and finish in order to determine weekly Student loan amounts. Even I
can do the formula for that one

Thanks again!

Alan