I have a date (TODAY()), and I have a number of months in a google sheet. How can I get a future date from this? I tried =DATE(TODAY()+MONTH(B63)). But the problem is that the months in B63 are not in date format, they are just an integer. So it can say 26 for example, or 3. How can I make this work? Can I make this work?


The function you need to use is the EDATE


enter image description here

  • Yes, works, thank you! – Darakir Feb 19 '20 at 15:07

Could you share a test sheet? From what it sounds like in your post this should be the answer, but it could be different.

I just did some research, and the function you're likely looking for is the


function, which takes a date value and adds a set number of months.


Edit Note: I removed the majority of my previous answer because it was overly complicated. This solution is far simpler.

  • This works perfectly, thank you! – Darakir Feb 19 '20 at 15:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.