I currently have this formula in a calculated field in SharePoint.

=IF(TEXT(Created,"mm/dd/yyyy hh:mm")="12/30/1899","",(TEXT(Created,"mm/dd/yyyy")))

This returns the Created Date in Text form.. but since our SP server is on the west coast. There is a 3 hour lag in time.

How would I add 3 hours to this formula?

3 Answers 3


Since adding Specific numbers is whole days, [Created] + 1 would be Adding 1 day, you can cut the value in to 24 parts and add specific hours.

[Created] + (3/24) for 3 hours


Try this.


referenced thread

enter image description here


Thank you, this is solved the date compare with current date for Birthday list in SharePoint (IST):


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.