Convert Month to Number or Text


If we use the the MONTH function to convert a month - for example "Jan 15" which is month formatted to Number, the outcome is "1" and not "01"

My requirement is to turn "Jan 15" as 201501. So I wanted to convert Jan to 01 instead of 1 and after that I can concatenate to get the result. What would be the way to convert Jan to 01 instead of ?


  • Hi @khoonks ,

    Similar to MONTH function, we have YEAR function to retrieve respective year value in number format.

    To convert 1 to 01 for Jan, you should use a small conditional statement with concatenation, as below:


  • Hi @khoonks,

    Here you go


    Aakash Sachdeva