Sos!

[excelsos]

Latest Recv Date

2017

2016

2015

2014 & Prior

<tbody>
</tbody>

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!