adding +1 month on selected date

[davinfrost]

hi guys, i have a problem,

i have this

=Day(date(MonthStart(max(FilterDate)),'DD-MMM-YYYY'))

how to add month + 1 on that FilterDate ?

thanks

[Arthur_Fong]

Try this:

Day(date(MonthStart(AddMonths(max(FilterDate),1)),'DD-MMM-YYYY'))

[davinfrost · Accepted solution]

thank you so much !

i used this 

date(AddMonths(max(FilterDate),1),'DD-MMM-YYYY')