Networkdays: Can this be worked out 'backwards'?

**Laurence Craig** · 11-21-2012, 06:40 PM

Hello. I'm new here, and I have what I hope is a do-able query.

I want to be able to work out the date a certain number of working days before another date. For example: What is the date 11 working days before the 28th of a particular month?

I've had a play with networkdays, but it's all getting a bit convoluted and abstract. Is there anyone out there who can easily crack this one for me, formula-wise? I'd be massively grateful.

**shg** · 11-21-2012, 07:06 PM

See the WORKDAY function.

**Steve N.** · 11-21-2012, 07:18 PM

Try the NETWORKDAYS function - see attached

Just reread your post - I think I missed the point - regrouping...

**Steve N.** · 11-21-2012, 07:36 PM

Looks like this works - see attached file.

**Laurence Craig** · 11-21-2012, 08:20 PM

Wow Steve, that was fast. You made it look so easy (I won't even show you the mess of cells and formulas I was using, even including networkday or workday; it's just embarrassing!) I'm looking to make a 'predictor' for 2013 months, that will produce a start date a certain number of working days before any end date the user chooses to enter, and you've given me just what I need to make it.

Thank you very much.

I think I'm going to like this forum...