=Month(Max(Date))-1 not working

[mahitham]

Hi Experts,

Can any one please help me on below requirement.

I have taken

=Month(Max(Date)) then getting Jun as Max Month

but when I have taken

=Month(Max(Date))-1 then getting 5 instead of May.

Please help me how to get May for =Month(Max(Date))-1 instead of number 5

Thanks in advance.

[sunilkumarqv]

try below

=Month(AddMonths(Date),-1))

=Month(Max(Date) -1 )

[agigliotti · Accepted solution]

let's try as below:

=Month( AddMonths( Max(Date), -1 ) )

[ChennaiahNallani]

try like below