Here is a macro that will insert rows for missing dates.
It assumes that dates are in an Excel recognized date format.
Enter the following in a standard module:
Private Sub MakeRows()
Dim lngRow As Long
Dim intCol As Integer
Dim lngRowCount As Long
Dim intIns As Integer
Dim m As Integer
Dim n As Long
On Error GoTo ErrHnd
'get start row
lngRow = Selection.Row
intCol = Selection.Column
'get number of rows
lngRowCount = Selection.Rows.Count
For n = lngRow To lngRow + lngRowCount - 1
'get difference in dates in next two rows
intIns = Cells(n + 1, intCol).Value - Cells(n, intCol).Value
If intIns > 1 Then
'insert row(s) and include next date
For m = 2 To intIns
Cells(n + m - 1, intCol).EntireRow.Insert Shift:=xlShiftDown
Cells(n + m - 1, intCol).Value = Cells(n, intCol).Value + m - 1
lngRowCount = lngRowCount + 1
End SubNote that Macros cannot be undone.
Always make a backup before using this macro.
As this macro has had very limited testing, please test it on copies of your worksheets, and as noted above always make a backup before using it on real data.
To use the macro, select the column of cells containing the dates. (I haven't included any check that the selection is only one column or that the column contains dates - these checks can be added if the basic macro works).
With the dates selected, run the macro.
The macro can be linked to a button on a toolbar, for regular use.