Count if Date Matches

[luisitocarrion1900]

=COUNT(Raw_Data[Week],44,Raw_Data[Region])

How can i change the above formula to count if the date under the header name Date in sheet Raw_Data matches the date in D2 or withing the week of the date under the calculation Sheet and the if the header named Count of assets in BU have data (if blank dont count) count

 

[rhobert]

=COUNT(Raw_Data[Week],44,Raw_Data[Region])

How can i change the above formula to count if the date under the header name Date in sheet Raw_Data matches the date in D2 or withing the week of the date under the calculation Sheet and the if the header named Count of assets in BU have data (if blank dont count) count

Have you tried COUNTIFS or introducing a helper cell that with an AND function?

 

[luisitocarrion1900]

i have been trying to add the below but is not working

=AND(Raw_Data[@Date]>=Calculation!$D$2,Raw_Data[@Date]< calculation!$d$2+7)