Conditional Formatting Help

[Scott]

I have a report that lists each day starting at the
current date. I use Date() for the first column, Date()+1
for the second, and so on. This goes until Date()+20 at
the end, so it gives me three weeks. Since I dont see a
way to filter out the saturdays and sundays (If there is,
it would be alot better), Is there a way to use
conditional formation or something else to highlight the
Saturdays and Sundays. Thanks for your help.

 

[Fons Ponsioen]

You could use the weekday() function.
For instance on Nov 3rd 03
Weekday(Now()) returns 2, Sunday is 1 through Saturday is
7.
Hope this helps.
Fons