Shark,
1 day wont make any difference if the month is the same. Most of our reports are generated on monthly basis so now that I am sure the date is always messed up with by one day, I just need to reload the excel sheets that have data for weeks that overlap between two months like 9/27 - 10/1.
This way I'll have to upload just 20 files instead of 200+ files..
It does make my work a lot easier.
Thanks a lot for your time 🙂