count common cell entries within 2 ranges

[jammoca]

I have dates within range F7:BB7.

I have another range that also have dates as entries ... BW10:DO10

I'd like to have a formula that couns how many cells within those 2 ranges share a common date entry.

I'm assuming it will be a countif formula, but can't seem to figure it through.

Kind regards

Chris

 

[mirabeau]

I have dates within range F7:BB7.

I have another range that also have dates as entries ... BW10:DO10

I'd like to have a formula that couns how many cells within those 2 ranges share a common date entry.

I'm assuming it will be a countif formula, but can't seem to figure it through.

Kind regards

Chris

Chris,

Not a formula as you requested, but, if only for interest

Sub in_common()
Dim b(50000) As Byte
Dim rng1, rng2, c, k As Long

rng1 = Range("F7:BB7")
rng2 = Range("BW10:DO10")

For Each c In rng1
    If Len(c) > 0 Then b(c) = 1
Next c

For Each c In rng2
    If b(c) = 1 Then b(c) = 2
Next c

For Each c In rng1
    If b(c) = 2 Then k = k + 1
Next c

MsgBox k & " dates in common"

End Sub

Also, to clarify.
If you have 2 dates the same in the first range and one date equal to these in the second range, do you count this as 3 cells sharing the same date, or only 2?