how to create a varaible which will give previous month of maximum month

[#1]

Please help me to create a varaible which will calculate previous month of maximum Month.

So if  maximum date is 8/8/2014 it should give output as July 2014.

max(date)=8/8/2014

month(max(date)& year(max(date)=August 2014

so previous month of August 2014 is July 2014.I want to create variable which will give this as output.

[MK_QSL · Accepted solution]

=Date(AddMonths(Max(Date),-1),'MMMM YYYY')

[#3]

Thanks a lot Manish !!

Thanks for quick response