SOLVED

Need help with date function

New Contributor

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. 

60Jan-27
30Jul-22
139 
5Oct-22
9Feb-23
4May-23
7Sep-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 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

Hi @yayab74

 

You would use edate function 

=edate(start_date, months)

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

Thanks so much, it worked. Thanks