Month not displaying correctly

Brandon E

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?

 

Brandon E

I should have added that this is the formula I am using

=IF(ISBLANK([Posted Date]5), 0, MONTH([Posted Date]5))

J. Craig Williams

This is, unfortunately, a known issue related to the way Smartsheet stores the underlying date.

This post, while long, covers it:

https://community.smartsheet.com/discussion/utc-date-fix-response-required

Craig

Brandon E

Craig,

Thank you for taking the time to respond. Seems like a major issue that needs to be addressed. 

J. Craig Williams

I agree.