| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Create calander
Ideally I'd like to create a calandar like this:
1. Put "01/02/04" in a cell A1 and in cells B1 to B35 I get returned each day in Feb listed eg: Mon 1st Feb, Tue 2nd Feb etc. 2. I don't want to run into March so I can't use 1/2/04 +1, +1....+31 because I'll get 3rd March in the Feb calculation, but 31st Oct in the Oct calculation! 3. Can I do the above but only show working days (Mon-Fri). 4. Finally. Can I draw a line at the start of every Monday. Any help to any of the above gratefully recieved Many thanks -- Peter London, UK |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i create Lorenz curve in Excel???? | Charts and Charting in Excel | |||
| How do I create a bar graph with floating bars? | Charts and Charting in Excel | |||
| create a chart with a formula | Charts and Charting in Excel | |||
| Is there a way to create a standard OHLC bar chart in Excel? | Charts and Charting in Excel | |||
| How do you create a macros without overwriting the previous one y. | Excel Discussion (Misc queries) | |||
Threaded Mode
