Return value of column if greater than year.

[SammyGP]

Hello all,

i want to create 2 columns: Column C > Year; Column D < Year.


In column A i have a date

IN B I have a Value Ie $200

I have tried:

=IF(TODAY()>360,C1,0)
=IF(YEAR(H26)>=C1,B,0)

Pretty much at a loss now?

thanks