[SOLVED]Time Card Auto highlight Sunday

**blues_oo7** · 04-13-2010, 11:33 AM

Outstanding Morning,

Can you please help me to AUTO HIGHLIGHT SUNDAY in my time card....
please see the attachement for details.

THANK YOU IN ADVANCE

**tony h** · 04-13-2010, 12:15 PM

use Conditional formatting on your dates. Choose Use a Formula.

Aformula of this type should work:
=WEEKDAY(A19,1)=1 where A19 is your date cell.

Make sure the formula doesn't get wrapped in quote marks

**blues_oo7** · 04-13-2010, 12:20 PM

Wooowww thank you sir tony

**blues_oo7** · 04-13-2010, 12:44 PM

Sir tony When i try to change the date its not accurate again, i dont know why.
can you please attached my sample w/ this code, TY

**tony h** · 04-13-2010, 01:06 PM

looking at your spreadsheet the dates in the first time cards are all actual dates starting with the date in AB5. (next day is AB5+1 etc)

Cell A50 is not a date. It is a number : plain ordinary 16. It should be a date.

There should be a formula in A50 of =A31+1

Then I think (if you check for similar problems) your problems will go away. It looks as if you should only need to change the date in cell AB5 to get time cards for a new date.