if formula to differentiate between months

[questforexcel]

Hello,

I need some help with my data with different months across a financial year.

I want to pull out ending month data, so where the date changes from one month to another eg. Sept - Oct - different month so pick the ending value shown in the column, else 0.

The idea is that I want the end of month figures for that month from my daily list of transactions.

The formula that I used is =IF(LEFT(F42,3)<>LEFT(F42,3),K42,0)

When I use this formula between Sept and Oct it shows this as false, meaning its not different. Could you help me place a formula based on the month, where it would not differentiate between days but between month values.

[TABLE="width: 89"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Sep-16[/TD]
[/TR]
[TR]
[TD]Oct-16


[/TD]
[/TR]
</tbody>[/TABLE]

 

[gaz_chops]

Not sure what you are trying to do, the formula you have is checking if F42 doesn't equal itself!

 

[questforexcel]

My Apologies, thats true.

=IF(LEFT(F11,3)<>LEFT(F10,3),K11,0)

This is the correct formula.

Even when I use the formula to check with the cell above, it doesn't display the right value.

For eg. for two same month value, it will show them as different.

I see it may be because when I use LEFT, RIGHT or MID functions it reads the date as "numbers" is there a formula which could help read the date as the visible characters / texts.

I want it to differentiate between the visible month name. If different then show the value in the adjacent cell, else 0.

Thank you

 

[jtakw]

Hi,

Assuming Real Date values in your cells, if you Don't need to check the Year also:

=IF(MONTH(F11)<>MONTH(F10),K11,0)

 

[gaz_chops]

Try

=IF(month(F11)<>month(F10),K11,0)

 

[questforexcel]

Thank you for the prompt assistance.

Hi,

Assuming Real Date values in your cells, if you Don't need to check the Year also:

=IF(MONTH(F11)<>MONTH(F10),K11,0)

 

[questforexcel]

Thank you for the quick reply

Try

=IF(month(F11)<>month(F10),K11,0)

 

[gaz_chops]

you're welcome