Hi All,

I am facing an issue with finding a single function to find the previous month. Previous month calculation should be dynamic in nature as the list of months are given in a drop down and we have to calculate the previous month of the selected month. One of the solution is working fine which is
=TEXT(DATEVALUE(B11& " 1")-28,"mmm")(Where B11 is selectable month) but i would need just one function to solve this problem.

Thanks in Advance