VBA - Copy certain range between two dates in the same row

Judging by its result, the code below seems like a far way from what you probably expect but it does show you how to select the range you want to copy. Therefore it should be helpful. The problem isn't with the selection of the source but with the formatting of the target.

Sub findAndCopy()
    ' 169

    Dim Kursplanung     As Worksheet, Test As Worksheet
    Dim DateRng         As Range
    Dim DayStart        As Variant
    Dim DayEnd          As Variant

    ' Set sheets
    Set Kursplanung = Worksheets("Kursplanung")
    Set Test = Worksheets("test")

    With Kursplanung
        Set DateRng = .Range(.Cells(5, 1), .Cells(5, .Columns.Count).End(xlToLeft))
        DayStart = Application.Match(Test.Cells(5, "C").Value2, DateRng, 0)
        DayEnd = Application.Match(Test.Cells(6, "C").Value2, DateRng, 0)
        If IsError(DayStart) Or IsError(DayEnd) Then Exit Sub

        .Range(.Cells(6, DayStart), .Cells(12, DayEnd)).Copy Test.Cells(5, "E")
    End With
End Sub