I need a calculated column to return the
mmm of a Date Field. Except, if the Date Field is empty, I would like the calculated column to also be blank.
The original formula for the month is
=TEXT([Date],"mmm"). This returns 'Dec' if the Date field is empty.
=IF(ISBLANK([Date]),"", &TEXT[Date], "mmm") but am getting an error.
Is this sort of thing possible?