Zend certified PHP/Magento developer

Excel: What is a formula for automatically inserting today’s date as static value?

I have a form with 3 columns

Date          Item     Cost
10/feb/2022   pc       100

I want to enter the data by using the “Form” button which brings up a popup to easily create a new record but I don’t want to manually enter today’s date each time (only the time and cost). TODAY() of course doesn’t work because on the next day all the previous dates will be changed to today’s day.

The highlighted Date column should be automatically filled with today’s date (11-feb-2002).

enter image description here