Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calender in E2007
Hi,
I'm on my way to create a Calender in Excel and there is something that bothers me. For some reasons I have to set up the Data entered in one Column in a special way, that means I have to enter my Data in the following scheme: Repeat infinity { Repeat 3 { Night [5 Days] Weekend } Reapeat 3 { Late [5 Days] Weekend Early [5 Days] Weekend } } So I have to determine the first day(night) of a night-block and have to care about the jump to the next month. How can I achieve the first thing? The Second is the problem to jump from one Column to another. The highlighting of a certain time is of no problem, as I've done this already. e. g.: a1: Date ;B1: [N/L/E]; C1: Special; d1: Date[next Month]; e1: [N/L/E] .. Please help me, somebody M |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
E2007 formulas display as formulas, not results | Excel Worksheet Functions | |||
E2007 - Macro for splitting text and then replacing something | Excel Discussion (Misc queries) | |||
open a workbook without running Workbook_Open macro in E2007 | Excel Programming | |||
Adding and Graying MAXIMIZE button on vba E2007 form system menu | Excel Programming | |||
Anyone having Ctrl+C / Ctrl+V problems in E2007? | Excel Discussion (Misc queries) |