Formula to produce the nearest business day

[pleiadeez7]

I have a list of office holidays - some of which fall on a Saturday or Sunday. For example, July 4, 2009 falls on a Saturday but the business holiday will be observed on July 3, 2009. Is there a formula that I can use to adjust the date to the nearest business day (Sat. observed on Fri. and Sun. observed on Mon.)?

Thanks in advance!

[Ron Coderre]

With
A1: (any date)

The below formula follows these rules:
• If that date is a Saturday...return: the previous Friday date
• If that date is a Sunday...return: the following Monday date
• All others...return the same date

Please Login or Register  to view this content.

Examples:
For 04-Jul-2009 (a Saturday)....formula returns: 03-Jul-2009 (Friday)
For 05-Jul-2009 (a Sunday)....formula returns: 06-Jul-2009 (Monday)


Is that what you're looking to do?

[pleiadeez7]

Thank you, thank you, thank you! That worked like a charm. You would not believe the hoops I have jumped through trying to do that. I should have asked a professional in the first place!