regarding recognition of date & after recognition value placement in the designated cell

[determinedtoexceed]

Dear Pros,

Is is possible for cell to recognize of date(month) & after recognition, it places the desired value in the designated cell?

In this case, for APAC01, I want "2640" of "8/30/19" in Aug cell.

Thank you so much for the help.

 

[jorismoerings]

Hi,

something like this:

Book1
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Jan	feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	ETA1	Qty	ETA2	Qty
2								2.640,00					8/30/19	2640
Sheet1

Cell Formulas
Range	Formula
I2	=IF(AND(YEAR(DATEVALUE("1/"&I$1&"/2019"))=YEAR($N2),MONTH(DATEVALUE("1/"&I$1&"/2019"))=MONTH($N2)),$O2,0)

 

[determinedtoexceed]

Hi,

something like this:

	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Jan	feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	ETA1	Qty	ETA2	Qty
2								2.640,00					8/30/19	2640

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Worksheet Formulas Cell Formula I2 =IF(AND(YEAR(DATEVALUE("1/"&I$1&"/2019"))=YEAR($N2),MONTH(DATEVALUE("1/"&I$1&"/2019"))=MONTH($N2)),$O2,0) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Thank you so much for the help, it works well.
Can the function remove recognition of year?, only recognize month

 

[determinedtoexceed]

I figured out on removal of year from the function

thank you so much for the prompt response.