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

  • Extract First Sentence In Excel

    Let’s see how we could extract the first sentence in a paragraph n excel. There are scenarios when are faced […]

    Share The Knowledge
  • Find Last Day Of Next Month In Excel

    Let’s see how to find out the last day of next month from a given date in excel. Suppose we […]

    Share The Knowledge
  • Enable/Disable Macro In Excel

    Let’s see how we   can Enable or Disable macros in an excel workbook. Step 1 Click on File at the […]

    Share The Knowledge
  • Replace Asterisk In Excel

    We will see how to find and replace “*” in excel. As an asterisk is a wildcard character in excel, […]

    Share The Knowledge

Leave a Reply