Thread: date formula

I am looking for a formula to use the current day as a reference and return the value listed for the current date.

Ex: Row 1 has the dates listed.
Row 2 has a dollar value.

The formula should update the number each day based on the matching date in row 1 and the corresponding value below shoudl be returned.

This formula does not work like I want it to, but it is what I have been trying to get to work.

=IF(A1:F1,"<=" & DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())),A2:F2)


Thanks

Try something like this

=HLOOKUP(TODAY(),A1:F2,2)

That works great. Thanks TIPPYS!