Update cell value based on name and specific date

L

Leo1111

Joined
Jan 8, 2015
Messages
1
Reaction score
0
Hi!
I have 13 sheets.
on the first I have names and dates of vacations like:

Names From To
Name_1 2/3/2015 10/3/2015
Name_2 14/3/2015 24/3/2015

...........
Sheets from second up to 13 looks like (from january to december)

A B C D
Names 1 2 3 ---------------------------------------------- 31
Name_1
Name_2
.......
My users fill only first sheet with names ( may be few times) and dates of vacations.
I need formula on the sheets 2-13 in cells from B2 up to end of the month that change value in the cells to the "V"
exactly between dates and name_X filled on the first sheet
Thanks for help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Time decimal value help please 1
Need a little help with a custom function 1
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Function for returning quarter based on current date? 4
Reverse Index Match 2
Automatic filling of cells within a certain date range 1
Copy adjacent Sheet and name from a list 42
Receiving unexpected Duration 0

Top