Thread: Weekends
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob[_6_] Bob[_6_] is offline
external usenet poster
 
Posts: 2
Default Weekends

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