TestingTesting
New Member
- Joined
- Dec 20, 2016
- Messages
- 3
After searching, I just cant find what I am looking for I am hoping that you wonderful lot can help me out.
I need to convert the field "months owned" into the correct date in the past. However this can not be worked out from the system date, and as this date changes every time a test is run I would like to use an input box to dictate the date to start counting back from. I would also like to output this information into a separate sheet, and preserve the original data.
E.g.: Months owned: "24", Testing date from input box: "01/01/2017", purchase date output: "01/01/2015 00:00" (must be in this format)
Any clues? Even a starting point would be great. I would upload my workbook, but it is a beast! Any questions let me know, any help VERY much appreciated
I need to convert the field "months owned" into the correct date in the past. However this can not be worked out from the system date, and as this date changes every time a test is run I would like to use an input box to dictate the date to start counting back from. I would also like to output this information into a separate sheet, and preserve the original data.
E.g.: Months owned: "24", Testing date from input box: "01/01/2017", purchase date output: "01/01/2015 00:00" (must be in this format)
Any clues? Even a starting point would be great. I would upload my workbook, but it is a beast! Any questions let me know, any help VERY much appreciated