Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
try below
=Month(AddMonths(Date),-1))
=Month(Max(Date) -1 )
let's try as below:
=Month( AddMonths( Max(Date), -1 ) )
try like below