Assuming that you have year in A1 and month in A2 the formulas a

1) =DATE(A1,A2+1,1)-DATE(A1,A2,1)
2) =DATE(A1,A2,1)
3 =DATE(A1,A2,8-WEEKDAY(DATE(A1,A2,1)))
4) =DATE(A1,A2+1,1)-1

Basically the formula will give the output in the date format and you may
have to use format cells to make it as number.

I am not sure whether I understood your queries correctly. Correct me if I
my understanding is wrong as I am new to this group.

Regards,
Ram.

"George B" wrote:

I have a spreadsheet where you enter the month. The spreadsheet is organised
into weeks . The weeks run from Sunday to Saturday. I would like to be able
to enter the Month and then have excel enter :-
1.) the no of days in the month in a cell
2.)the opening date of the month in week 1 worksheet
3.) the closing date of the first week of the month (ie the first sat) in
week 1 worksheet
4.) the closing date of the end of the month in week 5 worksheet
Grateful for any help - thanks

--
Every decision you make - is a decision about who you are