I need a formula that will calculate a calendar day value from a working day value based on a given start date. For example I need to place an order for a part where the supplier has quoted me 4 working days leadtime. I’m placing the order today (Tuesday 5th August) so the calendar day value will be 6 as there is a weekend. If I’d placed the order yesterday, the calendar day value would be 4 (as delivery would occur on the Friday of the same week). I also need to exclude Bank Holidays. My spreadsheet looks like…
Cell A1- Order Date
Cell A2 – Leadtime Working Days
Cell A3 – Calculated calendar days leadtime
Any help you can give would be much appreciated.
