Calendar - vlookup based on dates
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
|