The main issue you had hear was the date field was not formatted as a date.I have changed the data type from string to date.
Please see attached. All the values you require are on the sheet you may just need to fiddle with the marks to get them in the right order.
Let me know if this helps
table calculation.twbx 21.2 KB