I am trying to set up a timesheet that will compute 8 hours of scheduled work time for everyday of the week Monday thru Friday. I have set up the timesheet to fill out the current month's days of the month to equal the day of the week. For example, the current month of January 2008, the 17th falls on a Thursday and the timesheet will already do that. What I am trying to do is make it, in a seperate cell, fill in "8" for the hours scheduled for that day if the day falls on a Monday thru Friday, but if the day is a Sunday or Saturday, then it would either put a "0" or leave it blank. I have already set this up so that it will use the current month automatically. The formula that I use for example to calculate the first day of the month is: =DATEVALUE((MONTH(NOW())-0)&"/1/"&YEAR(NOW())) and then I use the custom number format of "d" to print "Tue" in the cell. Is there a better way of doing this and is it possible to have Excel schedule the 8 hours of work time just for the workdays?