Excel - compare dates

[Duplatt]

I have a spread sheet that lists the maturing dates and amounts for many
Certificates of deposit.
I have listed all CD's and their mature dates (d,m,yyyyy) and values.
Several are maturing in the same year but different months.
I would like to list and total all values by maturing year.
I have ,in the same row as the mature date, a cell referencing the mature
date cell only formated "yyyy" to show the year only.
In another section of the sheet I have listed the years 2010 thru 2039 in a
row in adjacent columns.
Cell F32 is date 1/25/2010
Cell L32 = Cell F32 only formated "yyyy"
Cell P31 = 2010
Cell K32 is a dollar amount
Cell P32 has formula - if(L32= P31,K32,0).
Cell P32 always shows 0 .
Even though Cell L32 indicates 2010 it is interpeted as 40203, therefore no
match.
How can I correct this or is there another solution?
Thank you -- Duane

[Luigi Dalu]

io ho capito che avete da vendere strumenti eletronici no ho capito cosa
ciao
"Duplatt" <Dup...@discussions.microsoft.com> ha scritto nel messaggio
news:4EE3C75F-0E68-4841...@microsoft.com...