There are quite a few ways to reference dates.
Assuming we have dates of a year in cells A1:A366 and corresponding information in cells B1:B366, this formula can be used to look up today's date.
Note: If Column B did not have numerical values the above formula would return a #VALUE! error. The following formula work better in this case.
Must be entered as an array. (Push Ctrl, Shift and Enter simultaneously)