0

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?

1

The function you need to use is the EDATE

=EDATE(TODAY(),J4)

enter image description here

| improve this answer | |
  • Yes, works, thank you! – Darakir Feb 19 at 15:07
0

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

=EDATE()

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

=EDATE(TODAY(),B63)

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

| improve this answer | |
  • This works perfectly, thank you! – Darakir Feb 19 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.