# Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I want to be able to do a Count if on weekly dates, so that I can total how many enquiries were made in each week
Solved by C. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 07/12/2017 - 10:18
User 07/12/2017 - 10:19
hi
User 07/12/2017 - 10:20
I wanted to do a countif formula on sheet2 calculating how many enquires where made each week on sheet1
Excelchat Expert 07/12/2017 - 10:20
ok
Excelchat Expert 07/12/2017 - 10:20
wait pls
Excelchat Expert 07/12/2017 - 10:20
smth wrong with date format below row 6
Excelchat Expert 07/12/2017 - 10:21
03/11/2017 is nov 03?
Excelchat Expert 07/12/2017 - 10:21
or mar 11?
User 07/12/2017 - 10:21
3rd nov 2017
Excelchat Expert 07/12/2017 - 10:21
ok
User 07/12/2017 - 10:22
can i have the date as dd/mm/yyyy
Excelchat Expert 07/12/2017 - 10:24
yes i will change the format wait pls and stay online
User 07/12/2017 - 10:27
ok
Excelchat Expert 07/12/2017 - 10:32
User 07/12/2017 - 10:34
would i have to input the #week next to the dates
Excelchat Expert 07/12/2017 - 10:35
no
Excelchat Expert 07/12/2017 - 10:36
just put your new dates to column A
Excelchat Expert 07/12/2017 - 10:36
if any
Excelchat Expert 07/12/2017 - 10:36
then drag the formula in column B
Excelchat Expert 07/12/2017 - 10:36
and sheet 2 will be updated automatically
User 07/12/2017 - 10:37
ok
Excelchat Expert 07/12/2017 - 10:37
but for example if next time you have new week num which is not exist in
Excelchat Expert 07/12/2017 - 10:37
sheet 2
Excelchat Expert 07/12/2017 - 10:37
just add i there and drag the formula down
Excelchat Expert 07/12/2017 - 10:37
it will count
User 07/12/2017 - 10:37
okay thanks
Excelchat Expert 07/12/2017 - 10:38
welcome
Excelchat Expert 07/12/2017 - 10:38
Excelchat Expert 07/12/2017 - 10:38
forget to
Excelchat Expert 07/12/2017 - 10:38
rate our session :)
Excelchat Expert 07/12/2017 - 10:38
thank you
User 07/12/2017 - 10:38
thanks

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.