So I have an excel database where rows of data get updated on a regular basis. FYI, the data is transferred from a userform which puts it in the next empty row.

I want a column where the date is recorded when the data was entered. The data transfer starts in column C, and I have this in the B column:
Formula: copy to clipboard 
=IF(AND(C2<>""),(TODAY()),"")


My question is, will this formula retain the date when C2 has data, or if I open this file tomorrow, let's say for instance, would it show tomorrow's date? In other words, is the formula absolute or does it refresh?