I came accross this code from Norie and it works fine!
However I like to format the dates in Wednesday 20 Feb 2019 and would love to have sundays automatically in red.
Dim StartDate As Date
Dim EndDate As Date
Dim NoDays As Integer