Hello,

I am trying to create a column that would take a date from one cell and add 9 Months and 1 Day, therefore returning a date of 9 months and 1 day later. My issue is, while using the normal date on 31/12/2020 and 05/04/2020 dates, I get 02/10/2021 (wrong) and 06/04/2021 (right) dates. I need the date to be exactly 9 months and 1 day post the above dates but can not find a way to have it shown.

Please help.

My formula atmo - =IF(QIPS?>0,"N/A - QIPS",DATE(YEAR([Year end])+0,MONTH([Year end])+9,DAY([Year end])+1))

Please note the above is possible using EDATE in Excel which sadly sharepoint doesn't have! :(Please help!

## 4 Replies

There may be a more complex answer, but why wouldn't you simply add 271 or 275 days. But I will assume you really do want it the way you are saying.

I suggest you might try two calculated columns. First one is the date adding the 9 months. Then the second column is the first calcuated column plus 1 day making the calculation a two step process.

Thanks for your answer.

I can't just add days as I need as this is a one column interacting another column, therefore I can not just try adding multiple different days with one formula. These are deadlines. Basically, in one column its the dates of the accounting year ends, the payment deadline is 9 months and 1 day post year end. I have multiple companies with different year ends and therefore need accuracy for auto calculation.