Excel - IF Formula with dates 1

[BxWill]

Have the following if formula in Excel 2007 that is not displaying the desired result:

=IF(TRIM(Y7)<TODAY(),"Closed","Open")


10/1/2008 is in cell Y7

What modifications to the if formula is needed to display the desired result?

Thanks in advance.

 

[SkipVought]

hi,

You only need to TRIM TEXT data.

A REAL DATE is not TEXT. It is a NUMBER. If column Y contains REAL DATES then
[tt]
=IF(Y7<TODAY(),"Closed","Open")
[/tt]
and it it's TIME that you're concerned about, then
[tt]
=IF(INT(Y7)<TODAY(),"Closed","Open")
[/tt]
But it should make no difference in this specific instance.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[xlhelp]

Read Skip's advice above. Then, check: What's the short date in your Regional Settings? May be that's your problem.

Canadian eh! Check out the new social forum Tek-Tips in Canada.
With the state of the world today, monkeys should get grossly insulted when humans claim to be their decendents