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