Hello, I need to produce a spreadsheet (and graph) that shows the following:

1. Number of defects
2. Current date (to be used for an ongoing weekly report - ie: Mar 3, Mar 10, Mar 17)
3. Number of days a defect has been active (date reported to current date)

I'm new at this!
Any assistance would be greatly appreciated. Thanks