When using a formula that includes the TODAY function, the date is shown as the incorrect day.
Example Formula: IF (ISEMPTY([Date of Closure]), IF ([Status]="Closed,TODAY(),NOVALUE()))
Each time a record is recalculated, the calculated field will display an updated date. Internally, the "TODAY" function returns a serial number that represents the number of whole days that have elapsed since January 1, 1900. From the user perspective, the value returned by the "TODAY" function will display differently depending on the type of field to which the value will be returned.
This issue occurred due to the data and times being converted to Greenwich Mean Time (GMT) in the RSA Archer database. As a result, dates and times in calculations are returned in GMT. In this case you may want to explore using a different function like "NOW".