View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave O Dave O is offline
external usenet poster
 
Posts: 427
Default How do i fill in cells according to date

Got it- thanks for the file, that helped tremendously. I got the
results you're looking for by doing this:

1. Insert new columns B and C.
2. For each driver, populate the days of in B and C using integer
numbers, where 1=Sunday, 2=Monday, etc thru 7=Saturday. In the sample
data, the first three rows look like this:
....A.........B....C
Driver 1....7....1
Driver 2....1....2
Driver 3....4....5

3. Create conditional formatting for cell D1 (that cell is now Day 1
for Driver 1) with this formula:
=OR(WEEKDAY(D$3)=$B4,WEEKDAY(D$3)=$C4)
....and apply the format you desire. Copy that cell and paste it for
the rest of the days in the month and the rest of the drivers.

Let us know how it goes!
Dave O