Need formula help to offset time period

Options
niti
niti Member, ALL USERS, GroupMember Posts: 5 Occasional Contributor

Hi all,

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?

Thanks!