Hello,
I am trying to copy data from one file to another and it depends on the date. In one file I have every day since 1/1/2000. The other file excludes weekends and holidays. Is there a way to copy the data from the file without weekends to the file that includes weekends, while keeping the integrity of the date?
So maybe to better explain.....I have file 1 and file 2 and would like to copy file 1 to file 2 and end up with the desired result.
File 1 File 2 Desired
1/1 5 1/1 6 1/1 5 6
1/2 10 1/2 8 1/2 10 8
1/3 8 1/3 8 1/3 8 8
1/6 9 1/4 9 1/4 9
1/5 10 1/5 10
1/6 7 1/6 9 7
Thank you
Bookmarks