I have table with two date columns (date1 and date2) and 100 other fields from P1 to P100.
Requirement is to have another sheet which will have the two dates and based on the date difference 5 columns out of the P1-P100.
For example, if the dates are 01MAR2018 and 01Jun2018 then the second sheet should contain P3-P7 as F1-F5 (3 is the diff between Jun and Mar 2018).
Similarly, if the two dates in a row are 01DEC2018 and 01DEC2019 then the second sheet will contain P12-P16 as F1-F5. The second sheet will have Date1, Date 2, Date Diff, F1, F2, F3, F4, F5 ie 8 columns.
Please sign in to leave a comment.