Forum Discussion
Excel formula to calculate a date.
Is there an Excel formula that will allow you to enter a date in 1 box and it will calculate a fixed period of time. For example if I entered 31/12/2019 in one cell it would return an answer of 9 months later 30/09/2020 ??
1 Reply
Chuftybadge , it could be, for example, EDATE https://support.office.com/en-ie/article/edate-function-3c920eb2-6e66-44e7-a1f5-753ae47ee4f5
