Forum Discussion
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...
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.
Absolutely. I have a variation of dates as well as number of days. So an example of another cell would be 9/5 minus 5 days. Output should be 8/31 but that formula displays 8/30
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.
- This is perfect. I cannot thank you enough