Date Values Not Recognized by Formula

[omagoodness]

I need to lookup a table value based on a date in another cell (V7)
For example Column N has dates and Column P has a currency value in table tblCardTips. (table Columns indexes 1, 3 respectively)
In another cell, V7 there is a date.
I want the formula to match the date in V7 to the same date in the respective table column and then print the corresponding currency value from Amount column in Y7
The code I am using was working fine ut suddenly it returns a 0 even though the value of both dates is the same (43836 for the test date)

=IF(tblCardTips[@WeekEnd]=V7,tblCardTips[@Amount],0)

I'm a stumped student

 

[GlennUK]

How are you examining the values of both dates? You say 43836 is the result for both, but some methods of testing automatically convert text versions of date to Excel date serial numbers. You could try altering your formula to :
=IF(tblCardTips[@WeekEnd]=VALUE(V7),tblCardTips[@Amount],0)

 

[omagoodness]

How are you examining the values of both dates? You say 43836 is the result for both, but some methods of testing automatically convert text versions of date to Excel date serial numbers. You could try altering your formula to :
=IF(tblCardTips[@WeekEnd]=VALUE(V7),tblCardTips[@Amount],0)

I tested each date cell using

Value(celladdress)

adding the Value(V7) as you suggested works great. I think I know why. It's nice to get the help and I try to understand the answers so I can code and troubleshoot better as I Learn. Thank you so much.

How do I rate your answer and mark as resolved?

 

[GlennUK]

You've already Liked my answer ... so thanks for that. And your reply says solved, so that's letting people see that it's solved.