Thanks I have used =IF(A16="","",WEEKDAY(A16))
I just need to work out how to use the sumifs or sumproduct with my criterias???