Most valuable professional
  • Hot Topics

Excel Get previous month number

I'm using this to get the Month number; =MONTH(DATEVALUE(U2&" 1")) Can anyone show me how to get the number of the previous month, so that if the Month is January it would show 12?

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of September 14, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel