Thanks for that, but how do I pick up saturdays?

Regards


"Mike H" wrote:

Try this

=IF(WEEKDAY(A1)=1,"Y","")

Drag down

Mike

"The Rook" wrote:

I have a list of dates in column A and would like to populate column B with
either 1 or Y is the date is a sat or a sun.