Excel formula

For gantt type chart I have a start date - in column I have =TODAY()-F9 the start date.  I want to show days completed - my issue that if todays date is past the end date, it continues to show todays...