Assume your dates are in column A, starting with cell A2. Highlight
all the cells, with A2 the active cell. Click on Format | Conditional
Formatting, and in the first box that pops up choose Formula Is rather
than Cell Value Is. In the next box put this formula:

=(WEEKDAY(A2,2)5

Then click on the Format button, and click on Colour (to affect the
foreground colour) and choose the colour you want (eg red). You could
also click on Bold, and if you click on the Patterns tab this affects
the background colour - you might choose bright green. You need to
click OK twice to exit the dialogue boxes, and then any cells which
have weekend dates in the range you had selected will now appear red
on a bright green backgound.

Hope this helps.

Pete

On Jul 4, 3:04*pm, Kerryn wrote:
The colour thing sounds even better. *How would I do that?

Thanks!!



"Pete_UK" wrote:
Assumig your date is in A1, use this:

=IF(WEEKDAY(A1,2)5,"ALERT","")

and copy down.

If you didn't want to use up another column, you could apply
conditional formatting to each cell so that it changed colour for
weekend dates.

Hope this helps.

Pete

On Jul 4, 2:47 pm, Kerryn wrote:
I have a date in the format dd-mmm-yy but I want a column next to it that
says ALERT if the date is a Saturday or Sunday. *What formula could I use?- Hide quoted text -

- Show quoted text -