To calculate a date five days before the first business day in Excel, you will need to use the following formula:
=WORKDAY(TODAY(),-5)
This formula will take the current date and subtract five days from it. If the current date is a Monday, then the result will be Friday of the previous week. If the current date is any other day of the week, then the result will be five days prior to the current date.