Formula for "MMM & "." & DD" Error

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()))

Try this:

=TEXT(TODAY(),"mmm. dd")

Thank you all. Your solutions worked perfectly.

Follow-up question however - I use a vlookup/match formula that searches through a Power Query table based on the formula for "MMM & "." & DD".

I get a a #N/A error message when I use the formula. However, the value from the table comes up when I type it in the cell manually as a 'mmm.dd' date.

Is this due to vlook/match formula unable to pull from a table or because the formula is not formatted correctly formulaically? I appreciate your insights.

I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"