MACRO, difference between a date and today : i have a range of dates from column E3:E, in column F, i want to have the difference in days of today-E3=F3, in F4= Today-E4 and so on until the last value in E. this is the code i have right now:

    'Calculate Overdue
    For i = 1 To lastrow
        If i = 1 Then
            Workbooks(Main).Sheets(1).Cells(i + 1, lastcolumn + 1).Value = "Overdue [days]"
        Else
            Workbooks(Main).Sheets(1).Cells(i + 1, lastcolumn + 1).Value = _
            Now - Workbooks(Main).Sheets(1).Cells(i + 1, lastcolumn - 1).Value
        End If
    Next i

help pleaseee