In column A, I manually enter the date of submitting photos to an organisation.

Column B automatically enters the month of this date - in text

What I would like to automatically happen in column C:

Look at the date in column A and then enter the date of the next Monday after this column A date

I have added a sample file to show what I mean ... Hmmm can't seem to add an .xlxs file attachment - so see screenshot above

Thank you very much for any assistance