TODAY() returning FALSE - What can be the problem?

Question

Hi everyone

I am building an automated calendar I have one table for typing the dates and a second one that will track all the main dates coming from there.

In this second one the cell display correctly the date using this function: =IF(ISBLANK(J8);"";J8)

But when I try to apply a conditional format it returns as a false. Any ideas why this function is not being read as a date? I highlighted the fields Im testing"

Answer 1

I fixed the problem.

Instead of using

*J32 has =IF(ISBLANK(J11);"";J11)

I just used the same function changing the additional days to 0 to keep the same date and everything works fine now:

=IF(ISBLANK(J11);"";WORKDAY(J11;0;holidays))

Thank you to Rory who politely tried to help.

Answer 2

If you change the cell format to say dd-mmm-yy does the displayed value actually change? If not, then your dates are stored as text, and that's why they don't match TODAY(). If they do change, then perhaps you have time values that are being suppressed by the number format?

Answer 3

The cells are formatted as custom dd/mm/yyyy

• What are you writing as the Conditional Formatting rule? two options of highlight:
  Format only cell contain > cell value > equal to > =today() > format with Yellow fill with dark Yellow texto
  Format only cell contain > cell value > less then > =today() > format with Red fill with dark Red texto
• What do you expect as a result? To use the dates to calculate all my deadlines and highlight due dates and past due dates
• What is the actual content of the cells displaying True/False? Each one has a triangle in its upper left corner... What does the message indicate? What is the format of those cells? For this only consider the first line:
  TODAY() was 14/11/2022 on the screen shot
  in TRUE I'm using the function =J50=TODAY()
  *J50 has this function =IF(ISBLANK(J11);"";WORKDAY(J11;2;holidays)) FALSE I'm using the same function struction=J32=TODAY()
  *J32 has =IF(ISBLANK(J11);"";J11) The triangle says they are unprotected formulas.
  Format is the same for all dates "custom dd/mm/yyyy
• the functions
• How does the Today() function factor into the issue? You don't even mention it in the message itself.

My point is, the source of the dates are the same, and the format as well, but depending on the function I'm using excel just don't read today() as being today. I clean the conditional formatting and did all from scratch and the results are the same. So I'm guessing the problem is in this argument: =IF(ISBLANK(J11);"";J11)

Answer 4

• What are you writing as the Conditional Formatting rule?
• What do you expect as a result?
• What is the actual content of the cells displaying True/False? Each one has a triangle in its upper left corner... What does the message indicate? What is the format of those cells?
• How does the Today() function factor into the issue? You don't even mention it in the message itself.

Please provide a complete explanation. Details are important. I'm sure it's all clear to you but nobody here has seen anything but static screen shots & a vague statement that whatever you're trying to do doesn't provide the desired result. The folks here are happy to help but you need to supply the complete picture.