Comparing two dates with VBA CountIfs

Question

I have two sets of dates (yyyy/mm/dd) in two columns, I want to check if the dates are the same or not. I tried the following line of code and it doesn't seem to work

If (Application.WorksheetFunction.CountIfs(completed.Columns(2), "=", row.Columns(5))) Then

Is it possible to compare two sets of dates with CountIfs?

Satheesh K · Accepted Answer · 2017-10-19 16:24:03Z

1

yes, it is possible to count the number of matching dates. but the countifs format should be followed correctly. May be you need some thing like below. please check your other code accordingly.

If (Application.WorksheetFunction.CountIfs(Range(completed.Columns(2)),row.Columns(5).value) = row.Columns(5)) Then

Format to use CountIfs

CountIfs(Range to check as range, Argument as value)

answered Oct 19, 2017 at 16:24

Satheesh K

1081 silver badge10 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Satheesh K Over a year ago

alternatively, why cant you use just a comparison of values? any limitation?

Satheesh K Over a year ago

do you get an error for correct format of Countifs or you tried to compare the values? If you were trying to compare values, share your code to verify.

Collectives™ on Stack Overflow

Comparing two dates with VBA CountIfs

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related