# Document Shred Schedule

#### mpricha

##### New Member
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
 2016 8-Jan 22-Jan 5-Feb 19-Feb 4-Mar 18-Mar 1-Apr 15-Apr 29-Apr 13-May 27-May 10-Jun 24-Jun 8-Jul 22-Jul 5-Aug 19-Aug 2-Sep 16-Sep 30-Sep 14-Oct 28-Oct 11-Nov 25-Nov 9-Dec 23-Dec

<tbody>
</tbody>

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

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

#### mole999

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

#### mpricha

##### New Member
"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

##### New Member
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

##### Well-known Member
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

Replies
0
Views
203
Replies
5
Views
272
Replies
11
Views
572
Replies
6
Views
375
Replies
4
Views
194

1,195,632
Messages
6,010,791
Members
441,569
Latest member
PeggyLee

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back