Compare Month to Current Date

  • Thread starter Thread starter KReiss
  • Start date Start date
K

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
 
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
 
One way:

=IF(MONTH(TODAY())>=MONTH(DATEVALUE("1 " & A1 & " " &
YEAR(TODAY()))), 7.5, 1)
 
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
 
Back
Top