Date Function not working

RedneckPrincess

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?

Andrée Starå

Hi,

It sounds like the Incident Date column isn't formatted as a Date type column. Is it?

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

Either that or the formula is in a Date type column instead of a text/number type.

RedneckPrincess

That was it.  silly me made it a date column.... thanks for the help!

 

Andrée Starå

Glad we got it working!

Best,

Andrée

Paul Newcome

Happy to help!