Date Function not working

Howdy Experts

I am trying to get a month number from a date in a corresponding column.  I use the function =MONTH([Incident Date]1) but i get back #DATE EXPECTED.  the date column has the date format of Jan 11, 2019.  I just need the month number in order to run a report based on incidents that occur in their corresponding months.  What am i doing wrong?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!