Sos!

[excelsos]

[TABLE="width: 1216"]
<tbody>[TR]
[TD="class: xl64, width: 109"]Latest Recv Date[/TD]
[TD="class: xl63, width: 65"][/TD]
[TD="class: xl63, width: 66"][/TD]
[TD="class: xl63, width: 44"][/TD]
[TD="class: xl63, width: 85"][/TD]
[TD="class: xl65, width: 44"][/TD]
[TD="class: xl63, width: 82"][/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl63, width: 65"][/TD]
[TD="class: xl63, width: 56"][/TD]
[TD="class: xl66, width: 51"][/TD]
[TD="class: xl63, width: 64"][/TD]
[TD="class: xl67, width: 44"][/TD]
[TD="class: xl68, width: 86"][/TD]
[TD="class: xl69, width: 64"][/TD]
[TD="class: xl70, width: 59"]2017[/TD]
[TD="class: xl70, width: 51"]2016[/TD]
[TD="class: xl70, width: 35"]2015[/TD]
[TD="class: xl71, width: 82"]2014 & Prior[/TD]
[/TR]
</tbody>[/TABLE]

So I have a col G with a Date (Any date from 2012 to 2018). I need it to read such that,if the date in ColG is 2014 and prior then the value from Col Q goes into ol Y(2014 & Prior), else returns 0.

Alternatively, if date in Col G(I want tracking by year) is say 2017, I want the value to go to Col V, 2016 Value from Col Q to go into Col W etc

 

[excelsos]

In addition - =IF($G6>=DATEVALUE("01/01/2017"),AND(IF($G6<=DATEVALUE("12/31/2017"),$Q6,0)))

I had this, but it is returning FALSE,if it does not equal, I need it to return zero

 

[philwojo]

Well at least for that formula you have the AND in the wrong place, try this:

=IF(and(($G6>=DATEVALUE("01/01/2017")),($G6<=DATEVALUE("12/31/2017"))),$Q6,0)

As for the rest I am busy with work right now maybe someone else can chime in.

 

[excelsos]

well at least for that formula you have the and in the wrong place, try this:

=if(and(($g6>=datevalue("01/01/2017")),($g6<=datevalue("12/31/2017"))),$q6,0)

as for the rest i am busy with work right now maybe someone else can chime in.

that worked!!! Thank you!