We will see how we could find the previous month from a date in excel.
We will see a simple formula in excel to get the previous month of a date and will use a custom format to display the desired result.
Step 1
Enter the formula below in cell B2, A2 contains the date for which we want to calculate the previous month.
=DATE(YEAR(A2),MONTH(A2)-1, 1)
Step 2
Now apply the custom format mmm-yy by right clicking the cell
Press OK
Hope this helped.