On 7 Jun, 12:03, "Bob" wrote:
I am trying to set up a function that will check the following

I am using Excel XP Pro

Bob,

I'd probably do it this way

=IF(WEEKDAY(F1,2)=6,F1+8-WEEKDAY(F1,2),F1)

HTH,
Barb Reinhardt

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