I'm completing a spreadsheet and want to auto-populate a date in one cell by the value in another . Dependent on the value in this other cell depends on how many days are added to the original date. Also when I do a basic select a date in a cell and do +1 (for example it keeps returning #### and I don't understand why?
So in this spreadsheet we want to auto populate the due date by whatever is selected from the priority drop down, and the number of days associated with this will be added on to the date in E2, (Opened Date)
Solved by V. H. in 14 mins