Vba Macro Help -Possibly a fomula

[DaveR]

What I am trying to achieve is this; I have a 'Date of refferal' in Column H, what I want to happen it that when this is filled in, Column I then offers two days which are either the following Wednesday, or the Wednesday after that?

All help greatfully recieved.

 

[DaveR]

Wow!

I'll have a play on my system and let you know!

Thanks so much for your hard work!

 

[DaveR]

D2 =SUMPRODUCT(--($B$2:$B$14=B2)*--($C$2:$C$14=C2))>1

The overlap formula doesn't appear to work.

Try it in your data with dates and times that are the same.

Or is it me? It has been a long day

 

[GlennUK]

It works for me. But I'm not taking into account time rounding errors, that could occur. This may work slightly better:

=SUMPRODUCT(--($B$2:$B$14=B2)*--(ABS($C$2:$C$14-C2)<0.001))>1