TODAY() returns today's date; NOW() returns the current date and time. They update automatically.
=TODAY() might show "2025-06-02" (depending on locale).