Formulae for Dates and Period calculations that can auto calculate with drop down

Hi,
I am unable to figure out the formulae for auto select start and end date with respect to transactions in the Data sheet at fixed intervals and further drop down in the Summary sheet performs the calculations automatically. I also need to extract the number of months for the specific period/s which gives results in segregating data and identify the number of months paid and unpaid. Thanks!