if then statements when 1 field is a formula

**shaunburke** · 09-24-2008, 10:41 AM

I'm trying to compare two dates to determine whether something has expired.

I'm using

Please Login or Register  to view this content.

C2 is a formula that says:

Please Login or Register  to view this content.

C2 will bring up the dates of last years trainings. However, it is not giving me the correct "yes" or "no". When I enter the numbers in manually, it works, but it will not pull from the cells with the formula. Any thoughts?

**NBVC** · 09-24-2008, 10:46 AM

Are the dates in the indexed sheet actual dates or text strings?

Does this fix it?

Please Login or Register  to view this content.

**shaunburke** · 09-24-2008, 10:49 AM

actual dates

**NBVC** · 09-24-2008, 10:51 AM

Possible to attach sample spreadsheet showing problem?

**shaunburke** · 09-24-2008, 10:54 AM

Okay, I found the problem. I imported the dates from Access, which for some reason, doesn't have them show up as numbers. As soon as I change them to numbers, they're fine.

How do I convert all of them to numbers without having to change each cell individually?

**NBVC** · 09-24-2008, 10:56 AM

That's what I was suggesting before....

Select the column and go to Data|Text to Columns and click Finish.

**shaunburke** · 09-24-2008, 11:05 AM

didn't seem to do it. I'm assuming that delimiting the column should convert them?

**NBVC** · 09-24-2008, 11:08 AM

Maybe try selecting the column again...

Go to Data|Text to Column and skip to the 3rd dialogue..

choose Date form the data column format area and then select the appropriate date format from the drop down menu.