Forum Discussion
Chuftybadge
Apr 13, 2019Copper Contributor
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 mont...
SergeiBaklan
Apr 13, 2019Diamond Contributor
Chuftybadge , it could be, for example, EDATE https://support.office.com/en-ie/article/edate-function-3c920eb2-6e66-44e7-a1f5-753ae47ee4f5