Wierd Date thing

[eddipowers]

<style type="text/css"> p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica} p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height: 14.0px} </style>Hi All


Can somebody please tell me why these statements come out this way?


K1 = 01/10/2018 (Dropdown list with value from a table formatted "mmmm ii")
J21 = 02/09/2018


=IF(MONTH(K1)&YEAR(K1)<MONTH(J21)&YEAR(J21);"TRUE";"FALSE") "Excel says True" (outcome 102018 < 92018)
=IF(MONTH(K1)&YEAR(K1)>MONTH(J21)&YEAR(J21);"TRUE";"FALSE") "Excel says False" (outcome 102018 > 92018)


=IF(YEAR(K1)&MONTH(K1)>YEAR(J21)&MONTH(J21);"TRUE";"FALSE") "Excel says False" (outcome 201810 > 20189)


I am using the statements in IF formulas, so it is pretty annoying.
Can somebody tell me what I am doing wrong or why excel is doing this.


Thanks in advance.

 

[shg]

May we know what you're trying to do?

 

[Dave Patton]

Excel 2010
	J	K
1		01-10-18
2
3		true
4		FALSE
5		FALSE
6
2b

Cell Formulas
Range	Formula
K3	=IF(MONTH(K1)&YEAR(K1)J21)&YEAR(J21),"true","false")
K4	=(MONTH(K1)&YEAR(K1))+0<(MONTH(J21)&YEAR(J21))+0
K5	=K1

You are comparing Text; you could coerce the Text to numbers.
or compare the original values (True Dates).

 

[offthelip]

you could try something like this:

=IF(YEAR(K1) +12*MONTH(K1)>YEAR(J21) +12*MONTH(J21),"TRUE","FALSE")

 

[eddipowers]

Hi thanks, guys!

It helps with adding a value to the functions. In my case, I used @offthelip 12* in front of the month. But you both have the same approach. Thank you very much for using time on this.