Counting blank cells with a concatenation based on the count value|General Excel Questions & Answers|Excel Forum|My Online Training Hub

I have seven cells in a row. I am trying to count the number of cells with a date, text or anything written on them.

The complication for me is I'm trying to figure out if its possible to provide a count of how many cells are not blank and add a concatenation at the end.

For example:

For the range of A2:G2, any 3 cells would have a date and cell H2 would have a summary indicating "3 trainings completed"

If the cells in this range are all blank, i would like H2 to simply say "No trainings Completed to date"