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?

Find more posts tagged with

Formulas

Comments

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!

Sign in to join the conversation!

Quick Links

Trending discussions

seeking VLOOKUP or equivalent, search for most recent value, multiple dropdowns
My product/use case: I seek to build a camera inventory. Each camera has a unique identifier. Cameras are mobilized to different locations on different days. I need help making a VLOOKUP or equivalent combination of formulae functions to run 2 queries cross-referencing 2 grids, searching a column with multiple dropdown…
Getting error message in approval email
Hey, Is anyone else facing this issue in the approval notifications sent through smartsheet
Add Package Count Based on Customer
I have a sheet with a list of customers in one column, and then the following columns are City, Monday, Tuesday, Wednesday, Thursday, Friday. I need help with a formula that I can put in my sheet summary so that if the customer column says Staples (It can say this in multiple rows) that it will tell me the total package…