Expert Solution - Excel IF Problems

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

Hello, how can i help you?

User 07/12/2017 - 10:19

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

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

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

Excelchat Expert 07/12/2017 - 10:32

please review

[Uploaded an Excel file]

User 07/12/2017 - 10:34

would i have to input the #week next to the dates

Excelchat Expert 07/12/2017 - 10:35

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

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