Need your help to create a time in days formula

Hello guys how are you doing I hope you are doing well,

This might seem like a similar discussion that I already made, and yes you are right but the difference is that I updated the data that I used and made it more accurate and more realistic and I have an example of how I want to make the formula, so before I start let me show you how the data is structured,

as you can see what I want to do is to have a "Time In Days" column which basically tells me the time in days from the moment we took the deal to the moment we closed the deal whether it's " Won " or " Lost " and in this case it's easy I take the " Close Date " minus the " Created On" and it will give me time in days on how long did we take to close the deal, but the problem is there are some deals that are open status which means that they are not closed yet like " Early Stage " and " Under Evaluation " and " To Be Qualified " and they don't have a " Close Date " because they are not closed yet, in my previous discussion I learned about the TODAY() function which gives me the date today in real-time and this is perfect for open deals to know how many days this deal is taking the thing I need you help on is how can I write a formula that says if the " Close Date " contains data which means it's a closed deal then take the " Close Date " minus " Created On " but if the " Close Date " is blank do this instead TODAY() minus " Created On ".

If my explanation is not clear here is a 2 min video in google drive explaining what I mean better

https://drive.google.com/file/d/1dVDzVowao1ylMxcGPWo2LwMQqpdCzoFU/view?usp=sharing 

And here is the link for the Excel file in google drive.

https://docs.google.com/spreadsheets/d/1HLrcIAox_ipGRSbPilR4QiubUY_2VaAP/edit?usp=sharing&ouid=109308642584924205993&rtpof=true&sd=true 

Thank you so much in advance I hope you can help me 

Windows 10