Formula Help!!

[Wilcock1]

Hi,

Please can you help with resolving a formula query that I have.

Cell AK2 is 01/01/19 (showing as Jan 2019 due to formatting)

Cell H227 I have 25/01/19

Cell L227 I have =IF(H227=0,"",H227) which shows as Jan 2019 again due to formatting.

Cell S227 has £20.00.

I would like my formula to be something like​

=if(L227=AK2, S227,0) which would show £20.00.

​

However, I am getting £0.00 which I think is either due to formatting or that 01/01/19 does not equal 25/01/19 but I want the result to work as both cells show as Jan 2019.​

​

Any assistance would be greatly appreciated!!

Regards

Andrew

 

[Marcelo Branco]

Maybe...

=if(MONTH(L227)=MONTH(AK2), S227,0)

M.

 

[Wilcock1]

Maybe...

=if(MONTH(L227)=MONTH(AK2), S227,0)

M.

Thank you Marcelo, that works! Thanks again.