Another way to do this is to write "on change" code for a certain
column or range of cells. The (VBA) code would direct Excel to replace
a cell with the formula =TODAY() if that cell was changed to T.

Do you want the TODAY() formula, which would change from day to day
because the date changes each day, or do you need a static value in
that cell that indicates the date you entered that T?