AnsweredAssumed Answered

Conditionally formatting weekend dates

Question asked by RickDearden on Apr 21, 2015
Latest reply on Apr 21, 2015 by RickDearden

Title

Conditionally formatting weekend dates

Post

Hi guys,

I have a report which shows timesheet entries.

What I would like to do is highlight each line who's Date is a Saturday or a Sunday.

The screenshot shows my layout and fields.

I have tried using:

Timesheets:Date = DayOfWeek ( 1 )

and the same for Sunday ( 7 ) in the Conditional format Formula field but this doesn't work.

Any ideas?

Thanks in advance :-)

Rick.

Capture.JPG

Outcomes