Based off of the current thread:

http://www.ozgrid.com/forum/showthread.php?t=75173

I borrowed some of the formula to help rectify my problem, however I need to add certain # of days depending on what day of the week it is. Here is what I have so far.

=IF(WEEKDAY(M7)=4,M7+5,IF(WEEKDAY(M7)=2,M7+2, M7+1))

M7 is a date entered by the user, This formula is in N7.

If the date is a Monday or a Wednesday, the formula works...

If its a Tuesday, it works (M7+1).

However if the date is a:

Thursday

Friday

Saturday

Sunday

I need the formula to determine that and add the appropriate # to bring it back to that monday.

For example, person enters 16 Aug 07 (Thursday) it needs to add 4 days to bring it back to display 20 Aug 07.

Any ideas, I think I would run out of IF statements for this formula.

Joe