THE PROBLEM/TASK

================

Column A contains a date value. I want to count how many of the dates are equal to today's week number, using the WEEKNUM(Today()) function.

Column B contains a "call number". The above mentioned countif function would have to if possible discount any "call number" that does not begin with "15"

I can solve this dilemma by creating a column C that calculates the week number from column A and then use a simple countif instruction to calculate how many calls for this week.

Can anyone help, please