Create a new column for Month

[jwadhwa00]

Hi! I am trying to create a new column in a sheet using the formula tool, that takes a date (YYYY-MM-DD) and produces a "month" column with the value as a string (ie JAN). I can't figure out what I am doing wrong and would love some help.

Screenshot of data sheet for reference; 

[binu_acs · Accepted solution]

@jwadhwa00 use the DateTimeFormat([Date],'%b') function

[jwadhwa00]

That worked! Thank you!