Using "If" with dates

Susan L.

Hi all,

I'm working on a sheet where I'd like to reference a start date for a task and then, based on the current date, auto-populate another column with a status update (not started, in progress, overdue, etc.).

I think I want an "IF" statement-something like "=IF([reference column])>today, "Not Started") but I"m 100% confident that I'm missing some bits there.

Here's a screenshot of some of my data (ignore the "health" column). I want "Start Date" to be compared to today's date and generate a status in the "Test Status" column (not started, in progress, overdue).

Thanks much for all of your help and suggestions!

A Rose

You can do both in Workflows, Create 1 workflow record a date, and another Workflow change type,

Let me know if you need more details,

Thanks,

Paul Newcome

You are going to want to start with something like this:

=IF([Start Date]@row > TODAY(), "Not Started", IF([End Date]@row > TODAY(), "In Progress", "Overdue"))

Susan L.

Thanks Paul-would it look like this:

=IF([Start Date]@row > TODAY(), "Not Started", IF([End Date]@row > TODAY(), "In Progress", IF([End Date]@row >TODAY (), "Overdue")))

With thanks!

Paul Newcome

You should be able to use the formula I provided above. If you did want to specify criteria for "Overdue", then you are going to want to change that argument from greater than to less than.