I am new and need help. I am setting up a spreadsheet that I need to calculate dates.

Example

I need to determine how long a project has been open to the point of being closed as well as how many days past due.

Thank you in advance for any help that can be offered.

C Pine