Month not displaying correctly
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?
Help Article Resources
Check out the Formula Handbook template!