Hi Kristina,

I really need your help with formula.

Thank you

"Kristiina" wrote:

I suppose first a "vlookup" for seeing if the name is behind some date (the
formula will also bring forward the date the name is behind) and an "if"
formula to see if it matches with the date. If it matches, the formula will
set a text "on vacation".
If you need help with the formulas, just let me know :)

Rgrds,
Kristiina

--
I help with Excel and PowerPoint
Office ToDo
http://www.officetodo.com

.