Hi

With your list of dates starting in A2 and your number that you want in B1, try this in B2 and copy down.

=IF(A2=TODAY(),$B$1,"")