View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Garnet Garnet is offline
external usenet poster
 
Posts: 6
Default 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.