pivotguy
12-11-2015, 07:52 AM
I have input sheet containing dates . I would like to find out what is the 7 calendar days from that input days.
The output file have all other attributes exactly same as input file, except the date. This can not be done manually
because the original file contains ~600 records. Any suggestion .
See the attached file contain 2 sample records.
Input
=====
Perform Name--> engine#-->Date-->system
=======================================
David Smith---->ACB098-->2/10/2015-->Laptop
OUTPUT
======
Perform Name--> engine#-->Date-->system
========================================
David Smith---->ACB098-->2/10/2015-->Laptop
David Smith---->ACB098-->2/9/2015-->Laptop
David Smith---->ACB098-->2/8/2015-->Laptop
David Smith---->ACB098-->2/7/2015-->Laptop
David Smith---->ACB098-->2/6/2015-->Laptop
David Smith---->ACB098-->2/5/2015-->Laptop
David Smith---->ACB098-->2/4/2015-->Laptop
The output file have all other attributes exactly same as input file, except the date. This can not be done manually
because the original file contains ~600 records. Any suggestion .
See the attached file contain 2 sample records.
Input
=====
Perform Name--> engine#-->Date-->system
=======================================
David Smith---->ACB098-->2/10/2015-->Laptop
OUTPUT
======
Perform Name--> engine#-->Date-->system
========================================
David Smith---->ACB098-->2/10/2015-->Laptop
David Smith---->ACB098-->2/9/2015-->Laptop
David Smith---->ACB098-->2/8/2015-->Laptop
David Smith---->ACB098-->2/7/2015-->Laptop
David Smith---->ACB098-->2/6/2015-->Laptop
David Smith---->ACB098-->2/5/2015-->Laptop
David Smith---->ACB098-->2/4/2015-->Laptop