Need help with date function

[yayab74]

I need help finding the right formula to show a date on months ahead. For example 60 months from April 2022 is what date? I want the formula to change based on different months ahead. 

60	Jan-27
30	Jul-22
139
5	Oct-22
9	Feb-23
4	May-23
7	Sep-23

In the cells above, I want to show what date (month and year) will be 30 months from Jan 2027, and so far from there. I hope its clear what I int

[#2 · Accepted solution]

Hi @yayab74

You would use edate function 

=edate(start_date, months)

=edate("26-3-2022,10)

[#3]

Thanks so much, it worked. Thanks