VB Code to summarize weekly Sales

Hello:

Please refer to attached file.

I have 2 sheets called Sales and Weekday.
As you can see Sales for Daily are shown in column L of Sheet "Sales".

I need a VB Code to summarize by Weeknum and day of the week as shown in "Weekday" Sheet.
Would need the Week Start Date and Weekend Date in column B and C.
I have manually completed for week 1
FY: My week start from Fri and ends on Thu.


Let me know if you have any questions.
Thanks.

Riz

FWIW:

Sub rizmoninzz()
Dim i As Long
Dim rcell As Range
With Application
    .Calculation = xlCalculationManual
    .ScreenUpdating = False
End With
For i = Range("D" & Rows.count).End(3).Row To 3 Step -1
    If Range("D" & i) <> Range("D" & i + 1) Then
        Rows(i + 1).Insert
    End If
Next i
For Each numrange In Columns("L").SpecialCells(xlConstants, xlNumbers).Areas
    SUMADDR = numrange.address(False, False)
    Range(SUMADDR).Copy
    Sheets("Weekday").Range("F" & Rows.count).End(3)(2).PasteSpecial Transpose:=True
        C = numrange.count
Next numrange
NoData:
For Each rcell In Range("D3:D" & Range("D" & Rows.count).End(3).Row)
    If Not IsNumeric(rcell.offset(-1)) Or rcell.offset(-1) = "" Then
        rcell.offset(, -3).Copy Sheets("Weekday").Range("B" & Rows.count).End(3)(2)
    End If
    If rcell.offset(1).Value = "" Then
        rcell.offset(, -3).Copy Sheets("Weekday").Range("C" & Rows.count).End(3)(2)
    End If
Next rcell
With Sheets("Weekday")
    For i = 3 To .Range("B" & Rows.count).End(3).Row
        With .Range("E" & i)
            .Formula = "=SUM(F" & i & ":L" & i & ")"
            .Value = .Value
        End With
    Next i
End With
Sheets("Sales").Range("A2:A" & Range("A" & Rows.count).End(3).Row).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
With Application
    .Calculation = xlCalculationAutomatic
    .ScreenUpdating = True
End With
End Sub

Hi John:

For some reason it seems not work.
Please refer to attached file.
Let me know if you have any questions.
Thanks.

Riz

It works for me? Activate Sales and run it.

Hi JieJenn:

Looks like your solution will work great.
i still need 1 more favor.
I would i make column L variable so that i can choose which column i want to add.
This way i can do multiple data study by choosing the column and see the data.
Please Please let me know if you have any questions.
Thanks.

Riz