Untitled

' Apply date format to columns B, M, and N
    With SourceWorkbook.Sheets(1)
        .Columns("B").NumberFormat = "m/d/yyyy"
        .Columns("M").NumberFormat = "m/d/yyyy"
        .Columns("N").NumberFormat = "m/d/yyyy"
    End With