Forum Discussion

JenAllen932's avatar
JenAllen932
Copper Contributor
Aug 29, 2023
Solved

Excel formula help

I am trying to find the best formula for the following situation. I want to take a date, subtract a certain number of days (will vary) and have the output only display Monday - Friday. If it lands on...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Aug 30, 2023

    JenAllen932 

    Take a good look at the formula:

    We subtract the number of days minus one from the date, then apply WORKDAY with -1 as argument.

HansVogelaar's avatar
HansVogelaar
MVP
Aug 29, 2023

JenAllen932 

With a date in A1:

 

=WORKDAY(A1-9, -1)

 

Format the cell with the formula as a date.

Resources