average of sales last 2 weeks (Actual Sales)

[#1]

I wanna ask, how to get actual sales for last two weeks.

• average of sales of last two weeks except sundays. (meaning: 12 days except sundays)
• average of sales of last two weeks only sundays. (meaning: 2 sundays)

NOTE: I will use this for trending sales and prior years.

Please attach files if necessary, thanks for your help.

Best regards,

Bill