Copy a date in a cell that is formated as a date
i have a layout where project managers fill in all relevant information into an intake sheet.
And then i have created some formulas and automation so that the project sheets would fill themselves upon creation. So far so good.
Now I have different date columns in the project sheet that need to be filed in with the right date. But i can't put a formula in the cell because its formatted as a date and one can't put a formula in a date cell.
Copying a whole row or column is not an option. I just need the cell for the end date of the project. Because the other dates in my project sheet calculate themselves in depending on the end date.
Is there a solution to my problem?