Inputting Blank Cell Formula into another Formula

[dhinze84]

Hello,

I am currently using this formula: =IFERROR(MIN(1, (DATEDIF(E8,TODAY(),"d")+1)/(DATEDIF(E8,F8,"d")+1)),"not started")

This formula shows me the percentage dates between start and end date, not going over 100% and indicating not started if the start date is in the future.

I need to embed a formula that will also indicate that Start Date (E8) that is blank that cell will also be blank. As of now if it's blank it shows 100%.

Thank you for any help.

 

[Fluff]

Hi & welcome to MrExcel.
How about

=IF(E8="","",IFERROR(MIN(1, (DATEDIF(E8,TODAY(),"d")+1)/(DATEDIF(E8,F8,"d")+1)),"not started"))