I need to transfer a set of date ranges into calendar rows
- or -
Post a project like this3001
$$
- Posted:
- Proposals: 7
- Remote
- #1024940
- Awarded
Description
Experience Level: Intermediate
I have a one worksheet with multiple lines of date ranges. The date ranges contain a employee, a start date, an end date and a description. They come from an external system and are therefore a random in order.
The second sheet should contain calendar rows per day. These calendar rows will contain one date per row. It needs to populate for each row the description for an event on that day. The columns will be the employees.
I have attached a sample sheet that contains one tab very similar to the output and on tab with static data what I expect.
So I need formulas that convert date ranges into formulas and lots of lookups I guess.
It ultimately needs to work in Google Sheets, so no visual basic.
Thanks!
The second sheet should contain calendar rows per day. These calendar rows will contain one date per row. It needs to populate for each row the description for an event on that day. The columns will be the employees.
I have attached a sample sheet that contains one tab very similar to the output and on tab with static data what I expect.
So I need formulas that convert date ranges into formulas and lots of lookups I guess.
It ultimately needs to work in Google Sheets, so no visual basic.
Thanks!
Sander Z.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
23 Jan 2016
Netherlands
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies