On Wed, Sep 9, 2015 at 6:46 PM, Brian Desmond <[email protected]> wrote: > Kurt- > > Is there a reason you don't always want the tapes retained for four weeks? Is > it that your > retention is defined as "a month" rather than say 28 days?
First - thanks for this. I appreciate it. But that's basically it - it's stated as 3 months. I could have just put it at 28 days (or 31 days, and corrected for the length of the month), but that still doesn't correct for the Wednesday delivery. > I assume your retention on the monthly tapes is "3 years" rather than 1,095 > days? Yep. > Anyway, I think I got what you laid out. I borrowed the formula from here > http://www.mrexcel.com/forum/excel-questions/523063-number-weeks-month.html > for part > of it. There's probably an easier way to do it but it was an interesting > problem for my short flight > this afternoon. I didn't figure out how to factor in leap years so your > annual retention is potentially > off by a couple days. I can certainly live with that. > If you simplify to retention in days rather than months it's way easier. I > posted it here if anyone wants to look. http://1drv.ms/1KFouIY Actually, I'm going to raise the possibility to management of putting it to being 42 days, rather than a month, or 28 days. I think that covers long months and holidays better. Until then, I'll work with your example. Unfortunately, the link you sent says it's empty, and there's no attachment to your email. Kurt
