One way

=IF(WEEKDAY(F9,2)5,F9-MOD(F9+5,7),F9-7)



--
Regards,

Peo Sjoblom



"Bob" wrote in message
...
I am trying to set up a function that will check the following

I am using Excel XP Pro

I have a date in cell F9. It places a date in F1 that will be 7 days
earlier. (This works fine)

Question:
If the date in F1 is a Saturday or Sunday, I need it to put the date of
Monday in that cell.

Does any one know the formula for this.

Thanks in advance.

bob