Calulate "Start Date" by subtracting "Duration" from "End Date"

G

Guest

I'm trying to calulate a "Start Date" by subtracting "Duration" from "End
Date". Here's where I'm stuck. I want the "Duration" to represent business
days rather than calendar days. Right now, for example, Monday - 1 = Sunday
where I want Monday -1 to equal Friday. Any thoughts?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help with date adding formulas! 7
Excel Forecasting Dates Out to the Day 3
Formula help: Duration Without Weekend Days 4
start date + net workdays = end date 1
Date and hourly time of use 3
Run a query based on a start date and end date. The date are the . 4
Subtracting START Date from END Date 2
Dates and Business days 4

Top