You could probably use an IF statement, but I am not sure how you would increment it each day.
=IF(Data_Entry_Sheet!A1=TODAY(),Data_Entry_Sheet!B1,0)
Maybe you could have the function check a range of dates, compare to todays date, then return the selected data. I'm not sure how help you with that though.![]()
Like this thread? Share it with others