Formula to convert a date into a number

[Spiru]

Hi guys,

Do you know a formula that converts a date with this format 2020/01 into the number of the month? E.g. 1

I've been looking on the internet and I couldn't find anything.

Thank you,

 

[etaf]

IS 2020/01 an actual date in the cell ?
formatted as date YYYY/MM

=MONTH(cell) will bring back the month

if its TEXT then
=VALUE(RIGHT(cell,2))
will extract the 01 and change to a number

 

[Spiru]

Thank you! It worked

 

[etaf]

you are welcome