Weekdays - Macro

Hi All,

I just want to record/write a macro that will hide Sat & Sun in a row of data. Sat & Sun will not always appear in the same cells.

I have a formula putting in the dates - it may be that one exists that will just bring back the day if it is a working day?

Hope one of you geniuses can help (again!)

Many thanks

Suzanne