CODEWITHSUNDEEP
google-sheets
deucalion0
deucalion0

Reputation: 2440

How to check if today's month date is greater than or less than a decimal number?

I have a column with month day numbers, so 20 means the 20th of the month.

I want to know how to check if a value in this column, say 20 is more than or less than today's month day.

I would use conditional formatting to color the cell in red if that day had not passed already.

What I tried to do was set a cell with today's date:

=TODAY()

Then based on this calculate if the month day was less than or greater by using this:

=DATEDIF(F2, "MD")

I was hoping this wold return a number which I could then do a compare with but this is wrong and I am not sure if what I want to do is even possible. I have read through the documentation and Stackoverflow but I cannot find any close examples.

Thank you.

Upvotes: 0

Views: 3029

Answers (1)

Robin Gertenbach
Robin Gertenbach

Reputation: 10796

If you want to check the day of the month you need to extract exactly that.

If your date is in Cell A1 and your threshold (20) in A2 the conditional formatting formula to check if the date has not passed yet would then go:

=DAY(A1) < A2

Upvotes: 1

Related Questions