Hi,

I would like to see if anyone can assist me with a date formula,

The the formula would need to do this,

1. its a formula that will look at only the 5 business days.
2. if its Monday, i want it to give me the date of previous working day Friday.
3. If its a Stat on Monday, then on Tuesday I would want it to give me Friday
4. If the stat is on a Friday and its a Monday, I would like the formula to give me Thursday.

and that sums it up,

Thanks soo much,

Noah