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
Bookmarks