Formula issue and need your help Excel 2013

hello

 

I have been trying to work out how to put some formula into excel using various functions and come to a complete blank.  What I have is a start date, end date, status column and I have a control cell with todays date in.  So I am working in Excel 2013 and need to setup a status column.

 

What I want to do is based on the Start Date column (D) and End Date (E) is link to status column depending on the timeline.  So should x criteria happen a predefined status would appear in the Status (F) column.  I have 3 Status 'Not yet started', 'Ongoing' and 'Overdue'.  Cell B1 I created as current date - TODAY().

 

I was trying to use various things from conditional formatting to basic formatting.

 

I was thinking something along the lines of (this clearly didn't work but starting point):

=IF(E5<B1,"Overdue",D5<B1,"Notyetstarted",D5>=,"Ongoing")

 

I tried something similar with IFS adding cell display name to columns and broke it down into stages but no luck there either.  I looked at maybe colouring the date cells to then macro colour to display text but my knowledge of that is limited.

 

Any help would be greatly appreciated.