There are various ways to write this. One method would be as follows:

Col A: Close

MM:=7;
DD:=26;
YY:=2004;
ValueWhen(1,Month()=MM AND DayOfMonth()=DD AND Year()=YY,C)

Col B: Month

MM:=7;
DD:=26;
YY:=2004;
ValueWhen(1,Month()=MM AND DayOfMonth()=DD AND Year()=YY,Month())

Col C: Day

MM:=7;
DD:=26;
YY:=2004;
ValueWhen(1,Month()=MM AND DayOfMonth()=DD AND Year()=YY,DayOfMonth())

Col D: Year

MM:=7;
DD:=26;
YY:=2004;
ValueWhen(1,Month()=MM AND DayOfMonth()=DD AND Year()=YY,Year())

Filter

MM:=7;
DD:=26;
YY:=2004;
ValueWhen(1,Month()=MM AND DayOfMonth()=DD AND Year()=YY,C)

 

Use of Columns B, C, D are optional ways to simply see the Month, Day, Year next to the closing price. Column A and the Filter would be the only required fields.

Edited by user Tuesday, December 1, 2015 10:28:36 PM(UTC)  | Reason: Not specified

Apologies as the formula originally in Col A was not correct (was providing current Close not the close at the specified date). New Column A formula should be the same as the Filter: MM:=7; DD:=26; YY:=2004; ValueWhen(1,Month()=MM AND DayOfMonth()=DD AND Year()=YY,C)