Return value of column if greater than year.

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

Hello and welcome to the forum.

I recommend uploading a small representative sample of your data along with the desired results (which you can enter manually) based on that data.

To upload an Excel workbook, follow these steps:
1) Click on "Go Advanced"
2) Click on "Manage Attachments"
3) Click on "Choose File"
4) Choose your file and click on "Open"
5) Click on "Upload"
6) Click on "Close this window"

the value of today() =

have a try with

for more than a year ago

Please Login or Register  to view this content.

for less than a year ago

Please Login or Register  to view this content.