Find Last Day of Next Month

[Tony2021]

Hello Experts,

I am trying to find the last day of next month from a date (ie FundDate)

I am using this: 

LastDayNxtMo: DateSerial(Year([FundDate]),Month(DateAdd("m",1,[FundDate]))+1,1)-1

==>BUT IT IS WRONG.  

here is the output:

you can see that when the FundDate is December then it returns January of same year and not the next year.  

I have attached a database if needed.  

thank you

[#2 · Accepted solution]

DateSerial(Year([FundDate]),Month([FundDate])+2,0)

[#3]

Perfect! thank you Arnel.