Excel Guides

Calculating a Date Five Days before the First Business Day in Excel

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.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.