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.
Enter the formula below in cell B2, A2 contains the date for which we want to calculate the previous month.
Now apply the custom format mmm-yy by right clicking the cell
Hope this helped.