insert space between date range

KennyMcG 

Or as

KennyMcG 
As variant that could be PivotTable

KennyMcG 

An alternative could be this code. You can change the data in column A from this:

to this by running the macro:

The code inserts a blank cell each time the day changes no matter if days are consecutive.

Sub insert_blank()

Dim i, j As Long

j = Range("A" & Rows.Count).End(xlUp).Row

For i = j To 2 Step -1

If Day(Cells(i, 1)) = Day(Cells(i - 1, 1)) Then
Else
Cells(i, 1).Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
End If

Next i

End Sub

KennyMcG 

If you're using Excel 365 and are open to using a formula:

dates = column with dates

=LET(
    UniqueDates, UNIQUE(INT(dates)),
    AddBlanks, LAMBDA(a, v,
        LET(
            filtered, FILTER(dates, INT(dates) = INT(v)),
            r, ROWS(filtered) + 1,
            resize, EXPAND(filtered, r, , ""),
            VSTACK(a, resize)
        )
    ),
    REDUCE("Dates", UniqueDates, AddBlanks)
)