# Formula Help!!

#### Wilcock1

##### New Member
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

Last edited:

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

#### Marcelo Branco

##### MrExcel MVP
Maybe...

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

M.

#### Wilcock1

##### New Member
Maybe...

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

M.
Thank you Marcelo, that works! Thanks again.