Compare Month to Current Date

[KReiss]

I have a column which is a text column that I spelled out
all of the months in a year . What I'm trying to do
is.........If Today()>=(the month colum) + 7.5, "". I'm
getting tripped up because I don't know how format the
month column so the computer can recognize it's a month,
but still have the names of the month spelled out.

Thanks in advance,
Kacy

 

[keyt]

Use the DATEVALUE function.

 

[KReiss]

Ok, I'm not following........I have in my month column
January
February
March.....
.....And I tried DateValue(January), but I get a #Value
error. Ultimately I'm trying to compare the current date
to my Month column and if its equal or already passed then
I want to add 7.5, otherwise don't add nothing. Hopefully
I'm close. Thanks for the help.

Kacy

 

[J.E. McGimpsey]

One way:

=IF(MONTH(TODAY())>=MONTH(DATEVALUE("1 " & A1 & " " &
YEAR(TODAY()))), 7.5, 1)

 

[Kreiss]

Thanks J.E.!! Thats exactly what I was looking for. One
more question.....do I need to concatenate year(today())
in the first part of the If statement. I noticed you had
it that way at the end. Thanks again.

Kacy

 

[J.E. McGimpsey]

No, any year will do.