Need formula help to offset time period
I am having some trouble determining how to combine certain time functions. I am trying to forecast sales with an associated start date and end date. The attached shows what I'm trying to accomplish. I've tried offset but I can't use that with a time period. Is there another way to offset a time period?