Update Values

Can I use a formula like TODAY() in the With These Values field?

You can update variable {{TODAY}} as field value, please refer to this article:

Can I use the variable on the update values custom button?

It can be used on update value in this sheet, but not supported on update value on another sheet.