I have 3 columns; Start Date, End Date, Progress
I can get the following formulas to work separately for row 17:
=IF([Start Date]17 < TODAY(), "In Progress", "Not Started") Returns in the Progress column
=IF([End Date]17 < TODAY(), "Overdue") Returns in the Progress column.
I want to combine these 2 formulas in one cell to return either; In Progress, Not Started or Overdue.
If there are no dates in the Start and End Date columns I want it to return blank in the Progress column.
Additionally I would like to use [Start Date]:[Start Date] instead of [Start Date]17 to cover the whole column, but it doesn't seem to work in either formula.
Thanks
Tom