two columns
column A-date
column B-value (source- input elsewhere, linked to workbook)

wish to have single daily value ( today() ) to plot, automatically
up-to-date, or how do i get a blank cell to correspond to column A with
column B's input, i tried
=if(A:A=today(),B:B,na()) and wouldn't work
thanks in advance!