I need to know how many times a Monday date appears in week 1 in a specific column, then how many Tuesdays appear in week 1 in the same column and so on. Then the same for week 2 and so on.
Basically I want to see, in week 1, how many jobs there is for each day of the week. Then the same for week 2 up till week 53. That info must display in the blue section named "Per week day". I already got the sheet to work out the week numbers acording to column U named "Req start" and also the total jobs in week 1 to 53 also is shown in column AO named "Total of week No. I will attache the whole work book named "Access report - xxxx". I only need the formula on sheet "To be scoped". I will take it to the other sheets as needed.
Bookmarks