Document Shred Schedule

[mpricha]

Hello - what i am trying to do is generate a schedule to shred documents. Currently my company is on a 2 week rotation, I want to be able to manipulate the shred schedule so that for instance, lets say one of the dates ends up on a holiday. Obviously that date will need to be changed. Criteria for documents to be shredded is that it must be at least 366 days past the contents date to be shredded. for instance August 27, 2014 can be shredded on August 28, 2014, but with the schedule i want it to be able to determine when the next shred date is and input that data.

Example Shred date schedule
[TABLE="width: 64"]
<tbody>[TR]
[TD="class: xl63, width: 64, align: right"]2016[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]8-Jan[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]22-Jan[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]5-Feb[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]19-Feb[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]4-Mar[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]18-Mar[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]1-Apr[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]15-Apr[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]29-Apr[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]13-May[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]27-May[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]10-Jun[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]24-Jun[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]8-Jul[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]22-Jul[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]5-Aug[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]19-Aug[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]2-Sep[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]16-Sep[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]30-Sep[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]14-Oct[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]28-Oct[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]11-Nov[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]25-Nov[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]9-Dec[/TD]
[/TR]
[TR]
[TD="class: xl64, align: right"]23-Dec[/TD]
[/TR]
</tbody>[/TABLE]

Using the Shred schedule for 2016 i can determine when these following dates can be shredded. I would like to use some type of formula or lookup tool to speed the process up.


File ShredDate
1-Jan-15 8-Jan-16
2-Jan-15 8-Jan-16
3-Jan-15 8-Jan-16
4-Jan-15 8-Jan-16
5-Jan-15 8-Jan-16
6-Jan-15 8-Jan-16
7-Jan-15 8-Jan-16
8-Jan-15 22-Jan-16
9-Jan-15 22-Jan-16
10-Jan-15 22-Jan-16
11-Jan-15 22-Jan-16
12-Jan-15 22-Jan-16
13-Jan-15 22-Jan-16
14-Jan-15 22-Jan-16
15-Jan-15 22-Jan-16
16-Jan-15 22-Jan-16
17-Jan-15 22-Jan-16
18-Jan-15 22-Jan-16
19-Jan-15 22-Jan-16
20-Jan-15 22-Jan-16
21-Jan-15 22-Jan-16

 

[mole999]

apart from today () - 14 does it have to be an exact artm you then end up with the two most recent weeks

 

[mpricha]

"Criteria for documents to be shredded is that it must be at least 366 days past the contents date to be shredded."
I pretty much need to be able to project the shred date the previous year.

 

[mpricha]

I see i made a mistake in the first post
"for instance August 27, 2014 can be shredded on August 28, 2014"
This should be August 28, 2015 - I apologize for the confusion.

 

[mole999]

I did think it was strange to be shredding important data within two weeks. so basically you need your cell to look at your contents date the last date you want live, then you add 366 to it which would give you . You could then select the column and add a conditional format that show red if it occurs later than today, and green before today. ANything that is green highlight you can then shread