As per my knowledge, if you use NOW() function to get current date and time in the formula of the calculated column, you will meet the re-calculated issue. Generally, Once you edit an item, the calculated column will be re-calculated and updated at the same time. As a result, you will always get current date and time in those calculated columns after editing the item. This phenomenon is by design and I’m afraid there is no way to change it currently.
I would suggest using a date time column or single line of text column as an alternative. Microsoft Power Automate Flow can be integrated with the list to set the current date to the fields based on the value in another field.
If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.