Date Function not working

RedneckPrincess · 07/21/19

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å · 07/22/19

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 · 07/22/19

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

RedneckPrincess · 07/23/19

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

Andrée Starå · 07/24/19

Glad we got it working!

Best,

Andrée

Paul Newcome · 07/24/19

Happy to help!

Date Function not working

Comments

Help Article Resources

Categories