return the month number of a date

Using the MONTH function will return the month number of a referenced date

DATE1

 

Enter =MONTH(A4) to get the month number of the date in the cell

DATE2

Get more great content from Rousseau Associates

Start your project with us today

Call +44 (0)1757 269461

Discuss your requirements today