Calculating weeks

  • Thread starter Thread starter Steve
  • Start date Start date
S

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
 
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
 
Back
Top