Greater than if statement not working on text

[Jaffabfc]

Hi,

So in cell G2 i have the formula of "=text(today(),"yyyy")"
in Cell H2 i have the formula of "=text(today(),"m")"


In cell D2 i have a countif of Column A
In cell C2 i have the formula of "=IF($H$2>D2,$G$2+1,$G$2)"

so what i am trying to get in cell C2 is if d2 is lower than h2 put g2+1 if not put g2 then drag it down

i think i have it in the forumla above but i recon its something to do with text.
Any ideas?

thanks

 

[etaf]

not sure why you are changing to text - is this for other reasons ?
if so
=text(today(),"yyyy")*1
=text(today(),"m")*1

will change the text into a number

or
=YEAR(TODAY())
=MONTH(TODAY())
will keep as a number

 

[Jaffabfc]

not sure why you are changing to text - is this for other reasons ?
if so
=text(today(),"yyyy")*1
=text(today(),"m")*1

will change the text into a number

or
=YEAR(TODAY())
=MONTH(TODAY())
will keep as a number

i always mess up when changing to text, its just a habit always forget the other ways of doing it.

 

[etaf]

*1 or +0 works
OR use --
=--TEXT(TODAY(),"yyyy")
=TEXT(TODAY(),"yyyy")+0
=TEXT(TODAY(),"yyyy")*1 - I always use *1 no idea why

 

[Special-K99]

Month comparisons should usually include the year as well.
For e.g. Is month 01 (January) greater than today's month 03 (March)?
No it's not, 1 is not greater than 3.
Oh, hang on,, I meant Jan in 9 months time, which IS later than this month.
Just doing a month comparison will return FALSE as shown above.
If you include the year 202601 IS greater than 202503.

Back to your problem.
If you're using COUNTIF then A is a number, and you shouldnt be comparing TEXT against a NUMBER.

Try using

=text(today(),"m")+0

 

[kvsrinivasamurthy]

Try.
For G2
=YEAR(TODAY())
For H2
=MONTH(TODAY())