NO ...=WEEKDAY(Today(),2)=3

the 2 signifies that Monday=1, Sunday=7

Look at WEEKDAY function HELP.

"Joe" wrote:

On Feb 21, 2:52 pm, Toppers wrote:
Try:

Select your cell and in CF:

FormulaIs: =weekday(Today(),2)=1 and set colour



Thanks to both of you, so am I to assume that if I want to change the
day to Wednesday it would be =weekday(Today(),4)=1