Underlying formula might be causing a problem with testing of =Today()

[jgold20]

In cell Z6 I have the following formula =IFERROR(INDEX(Input_Events,data!K3,2),"") that returns a formatted date (MM/DD). In cell AC6, I am performing the following test:

=IF(Z6=TODAY(),"CALL","")

When I have the current date (todays) in Z6, it returns a false test ("").

If I change the formula to <, it returns a true test (CALL)

Any help would be greatly appreciated

 

[pgc01]

Hi

This means that you don't have the current date in Z6.

Check their values

In a cell use: =TODAY()
In another: =Z6

Format these 2 cells as general and check their values.

 

[MARK858]

Does =ISNUMBER(J6) return TRUE or FALSE?

 

[jgold20]

Thank you. Yes the dates are different, however, the formula in Z6 is displaying right now 2/2 when formatted as a date.

 

[MARK858]

Thank you. Yes the dates are different, however, the formula in Z6 is displaying right now 2/2 when formatted as a date.

What does

=IF(INT(Z6)=TODAY(),"CALL","")

return?

If it doesn't work please post the values that were returned when you formatted the cells as General.

 

[pgc01]

Thank you. Yes the dates are different, however, the formula in Z6 is displaying right now 2/2 when formatted as a date.

The format doesn't matter. Excel compares values.

 

[jgold20]

The year value being picked up from a different sheet was with the underlying formula was 2012. I have rectified the problem.

Everyone, thank you

 

[pgc01]

I'm glad you figured it out. Cheers!