I have the following formula: =IF(E54="PCS",H54-183,H54-249)
This will give me a specific date. Sometimes this date falls on a Saturday, Sunday or Holiday. Is there a way to build the formula to check if the date is a Saturday, Sunday or Holiday and automatically adjust to the nearest previous Friday?
TIA!!!
Crystal
Bookmarks