How do I can show only MONTH value using Text Formula

[M-Way]

Anyone can help me, please?

This formula didn't work, I wanna show MONTH value from Column Value Reference [DATE]

IF([DATE] <> "", TEXT([DATE],"MM"), "")

[diogolupcosta]

Just put the: TEXT([DATE), "MM")

[Steve]

In what way doesn't your expression work?

[M-Way]

Holla Steve,

I wanna show only Month value automatically when [DATE] column isn't blank, before I need some help, my formula which is in above doesn't work even though I am very sure that my formula is corrected but the day after tomorrow (today), my formula works!

[Suvrutt_Gurjar]

Please try

IF(ISNOTBLANK([Date]), TEXT([Date],"MM"), "")

[M-Way]

Holla Gurjar, Thank you in Advice!