View Single Post
  #6   Report Post  
Scott
 
Posts: n/a
Default Calendar - vlookup based on dates

Declan,

You are AWESOME! Thanks so much for all your help above and beyond what I
could have expected.

Sincerely,

Scott

"DOR" wrote:

One issue that might be of interest is that the approach I recommended
will not work if an event extends across a weekend, without being held
on the weekend, e.g. a three-day event starts on Friday and ends on
Tuesday. Similarly, it does not work if an event spans a holiday. If
you want to handle those situations we need to make a small change.
Let me know if that is necessary.

Declan