I am trying to generate a future date based on the email date and cells value in an excel file.
Cell J22 input is obtained based on the email date that has been converted to string.
Hence, now I have difficulty to apply a formula in excel to obtain the future date (Next Review Due date)
Next Review Due date = ECDD Approval Date [Cells J22] + Review Period [Cell K22]
I am thinking to assign cell K22 as a variable, so that I can compute the future date via Uipath then paste it back to the excel file.
But I have no idea how to do about it.
Please enlighten. Thanks
Book1.xlsx (20.1 KB)
Main.xaml (29.9 KB)