Replicating excel based employee work...

Using Coldfusion MX7.?Trying to replicate an employee work schedule currently in excel.?The schedule is built out for the year and looks like so:

SHIFT	EMPLOYEE	SUN	MON	TUE	WED	THURS	FRI	SAT	1/4	1/5	1/6	1/7	1/8	1/9	1/10
1	James Brown		1230	1230	1230	1230			OFF					OFF	OFF
1	Mark McGuire		1230	1230	1230	1230			OFF					OFF	OFF
1	Mike Jordan		1230	1230	1230	1230			VAC	VAC	VAC	VAC	VAC	VAC	VAC
# AVAILABLE:										2	2	2	2

All of this data is now in SQL Server 2005 and now displayed on a webpage; but it is built out for the rest of the year (12/31/09).

So, to explain...?The table above shows employees working shift 1, Mon - Thurs (start time at 1230), and OFF on Sun, Fri, Sat.?The number available row shows how many employees they have working for the day.?I need a way to determine what the employees ''weekend'' days are (in this case, they have a 3 day weekend - Sun, Fri, Sat) so I can highlight the column, and not run calculations against those columns.?In this example above, I'm only showing 1 shift, but the other shifts work different schedules, so the column highlights would vary.

I'm wanting to know if there is a way to compare the times worked section (Sun - Sat) where it is NULL (Sun, Fri, Sat), and compare it to the dates section (1/4, 1/5, etc), and highlight accordingly/not run calculations.

Ideas?