Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2002 date entry: Cannot get away from d-m-yy entry format | Excel Discussion (Misc queries) | |||
Automatic Entry | Excel Discussion (Misc queries) | |||
How do I create an automatic date entry? | Excel Discussion (Misc queries) | |||
Automatic Date Entry | Excel Worksheet Functions | |||
Need help with automatic date entry | Excel Discussion (Misc queries) |