how to look for a date in a cell

Missy Folkemer

I'm trying to set up a formula that looks at one cell to see if there is a date in it. If there is a date, I want show the date but if there isn't a date, I want it to say "not set up yet."

Samuel Mueller

@Missy Folkemer You should be able to use the formula "isdate"

something like

=if(isdate(date@row), date@row, "Not Set Up Yet")

Missy Folkemer

What am I missing? =IF(ISDATE([Start Date]460, [Start Date]460), "Not set up"))

It is saying unparseable.

Samuel Mueller

@Missy Folkemer you just have a parenthesis in the wrong place.

Also, unless you are looking at a specific row, your formula should be

=IF(ISDATE([Start Date]@row), [Start Date]@row, "Not set up")

Missy Folkemer

This gave me an invalid column name. I am looking at a specific row. I have it like this now but this is what is giving the current invalid column error.

=IF(ISDATE([Start Date]130), [Start Date]130, "Not set up")

Missy Folkemer

nvm I found the problem, it was in the column property. Thank you!