I have extracted date in a form (dd.mm.yyyy) with Screen scraping - full text (while table was not redable with data scraping) and then with string manipulation got a desired form of date. I have also extracted loan duration which is given in a form of months (everything is a string variable). The end date should be as follows:
ED = dd.mm.yyyy + months = dd.mm.yyyy (new date should be in a same form as a start date).
Is there any “elegant” (short) solution how to solve this without using excel or e. scope?
Inside the Excel the solution is:
30.03.2017(date in cell A1) - start date
71 (number of months in cell A2) - duration in months
28.02.2023 (result in cell A3 using EDATE(A1;A2)) - end date
The above example should demonstrate what I want to achieve. I hope I was clear enough
I would very much appreciate the Help.
Thank you in advance,