Hello dvolaric,
I have read your instructions and I have examined the excel file as well. I can easily do the project for you, because I have been recently doing some excel automation (Macro / VBA) recently. These automations required extensive date/time data comparisons.
However if you select me for the job, I'll need to be more clear on a few issues before starting the work. They are as follows:
1. When you say "Go throw all PS Dates, find oldest date and write it in Cell E3" do you mean, all PS dates in all the rows? Rows 5,6,7,8 and 9 contain dates (in PS Dates). Shall we compare all these dates with each other? Or shall we do that on a row basis?
2. When you say "Columns with blank third row (no text) are ignored." - then shall we leave out the column "O" from this initial comparison? Or is it that, we'll include this in the comparison, but not put any template in TS (calendar)?
3."Find newest date and generate TS to next sunday after this newest date". I can do that, but please clarify what you mean by "generate TS". Is it just putting the right PS template in the date (following sunday date) in the calendar? But we have to do that for all the dates (except column O) in every row....isn't that right?
Whatever you need to be done, I can write a macro for that. It shouldn't be a problem for me.
So please message me if you want to clarify more, or if you want to know anything from me.
Thank You and Best Regards
Raad (BDtW)