Function on Sheet1 based on data on Sheet2

S

Sony

Hi, I am trying to forecast approved vacation for employees on sheet1 based
on information from sheet2. What I have is a summary page sheet1 with a list
of employees names in column A, a cell that populates Todays date. On sheet2
I have the following:

Columns B to AF the days of the week and the appropriate date for that
month. In the row above each would have the prospective month in this format
Jan-07 until all months are listed. For each month there are 11 rows with
employees names.

what I want to do is use date for Monday of each week and project who will
be on vacation for the next 2 weeks and summarize it on sheet1. Is this
possible? I had posted this same question in the programming section but did
not get any answers so I would really appreciate any help on this.

Thanks
 

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

Top