please help
I have a table with travels of people on business. With start date and end date , name of person, destination etc.
I want to create a dynamic calendar . separate worksheet with matrix where I have in column A the names of all the people and in first row the calendar dates.
For each cell in that matrix I need to have an (*) if that person (his name is in corresponding cell A$x) traveled on that date. I kind of need to vlookup in the above mentions table and see that the date is between the start and end dates of one of the travels that man did, and then put and asterisk (*) in that cell to mark it. I thought to create a formula that will kind of create a dynamic array of all the travels of some person and check that the date of the particular column is in the range.
thanks
Bookmarks