Can any one explain this. I have 3 columns, a date column, month and day columns. The month and day columns are calculated columns of the date column. DOB - Date/Time (Date only format) DOB_Month - calculated column - MONTH(DOB) DOB_Day - calculated column - DAY(DOB)

I entered a couple of records. Some of them work just fine. Some - the Month and Day calculations appear to be treating the DOB date as one day back. NOTE: all of these records were entered at the same time. If I edit a value in the list (ie: name), it saves out the record with the appropriate Month/Day values. Within 5 minutes, the list refreshes with the wrong values. Again --- ONLY A FEW RECORDS ... not all of them.


enter image description here

  • 2
    What is the regional, language settings and date format selected for this site? Maybe it is causing this problem. Commented Nov 23, 2022 at 5:12
  • 1
    Indeed like Ganesh I had similar problem, but behaviour was consistent and all dates were off by day. Please share the formulas you use for calculation. Commented Nov 23, 2022 at 13:09
  • Ganesh's direction was correct. I discovered the regional setting was not set properly. After correcting, all is working as expected. Commented Nov 28, 2022 at 20:09

2 Answers 2


According to my research and testing, your problem cannot be reproduced, which may be related to the formula you use. I used the following formula to test and it worked fine. DOB_Month column DOB_Day column The Result You can try to see if the problem is solved.

  • As Ganesh suggests - it was related to my site's regional settings. Once I configured the correct setting, all my entries started working properly. The inconsistent treatment was odd - and a day later, the 11 entries that were wrongly set went back to being wrong again. I deleted those entries and re-entered them - and now all is working fine. Commented Nov 28, 2022 at 20:08

The issue was the site's regional setting was set to Pacific time, where I am located in Easter time. Once I adjusted the setting, all the formulas worked properly. Days later - the data is still "in good standing".

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.