Extract Number from Date that has Format Applied

[amorrissen]

I have a date in cell A1 as follows: 4/1/2021

A1 has date formatting applied so the cell displays: April 2021

I want to extract just the numerical month value from A1.

I tried =LEFT(A1,1) but the result was "A" not "4". How do I get the numerical month and keep the date formatting?

[#2]

@amorrissen 

Use the MONTH function:

=MONTH(A1)

[#3]

@Hans Vogelaar Thanks. Works great!