Month not displaying correctly

08/24/18 Edited 12/09/19

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

Comments

Sign In or Register to comment.