Get Previous Month From A Date In Excel

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.

Capture




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)

Capture

Step 2

Now apply the custom format mmm-yy by right clicking the cell

Capture

Capture

Press OK




Capture

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply