Month not displaying correctly

Brandon E
Brandon E
edited 12/09/19 in Formulas and Functions

I have a sheet that contains a Posted column that is auto-populated with the created date. I have another column next to that that pulls the number of the month out of the date. Example would be the Posted column says created 03/11/2018 11:39 AM and the month column returns a 3.

The formula I am using works for every instance except one. The cell in question has a created date of 4/30/18 10:46 PM. The month column is returning a 5 for this date. I can't figure out why this is happening and it is the only instance that is incorrect. Any ideas?


Smartsheet Date Issue.png


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!