If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Calendar Formatting Based Upon Multple Date Ranges
Hi there, what I am after is simple enough in nature, but seems to be
difficult to create. Basically I work on a rotational job. Usually it is 4 weeks at site, and 4 weeks off. Sometimes that can Change to 6 on, 2 off, etc. I'd like to create a calendar that allows me to specify a start date, # days on, # days off, and have it format a calendar with simple colors for days working. I don't care what has happened up to this point in the year - just from the 'start day' forward. any suggestions would be appreciated. |
#2
|
|||
|
|||
Calendar Formatting Based Upon Multple Date Ranges
Try this
http://spreadsheets.google.com/ccc?k...lZGS nc&hl=en -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "Garnet" wrote: Hi there, what I am after is simple enough in nature, but seems to be difficult to create. Basically I work on a rotational job. Usually it is 4 weeks at site, and 4 weeks off. Sometimes that can Change to 6 on, 2 off, etc. I'd like to create a calendar that allows me to specify a start date, # days on, # days off, and have it format a calendar with simple colors for days working. I don't care what has happened up to this point in the year - just from the 'start day' forward. any suggestions would be appreciated. |
Thread Tools | |
Display Modes | |
|
|