View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
George B George B is offline
external usenet poster
 
Posts: 9
Default Automatic date entry

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