It's there now -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Kurt Buff Sent: Wednesday, September 9, 2015 10:38 PM To: ntsysadm <[email protected]> Subject: Re: [NTSysADM] OT-ish: date calculation in Excel
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
