Choose left 3 cell contents

[SeanEvans]

I have a list of dates ( an entire year ) in the format -

Mon 13 Dec 2004

However I only need the list to contain weekedays i.e. and would like to use a simpla macro to delete the lines that start with Sat or Sun. I just can't figure out the syntax of the command as so far I have been trying stuff like

If ActiveCell.Left(3) = "Sat" Then

to no avail.

Can anyone point out the correct syntax for me ?

Thanks

[Wellie]

You can use this

If mid(ActiveCell, 1, 3) = "Fri" then ' Where 1 is start of string, 3 is 3 characters
msgbox "It's Friday"
else
msgbox "Not Friday yet"
endif

Regard

[SeanEvans]

Thanks, I'd forgotten about that one.

[SeanEvans]

I've just realised that the cell contents are merely dates (10/10/04) but its simply the formatting that shows up as Sun 10 Oct 2004. So I'll need to work out if the dates are saturday or sunday then delete the rows.