Hello,

I am trying to build a data formula that will grab today's month and date and format it as follows - "Oct. 17".

The formula below works when it is split into two parts (month and then date), but does not work when I combine it into two. The error message I received is #VALUE.

I appreciate any insight and guidance. Please let me know if you may have any questions. Thank you!


=TEXT(MONTH(TODAY()),"mmm"&"."&DAY(TODAY()))