pumelayurika
03-16-2016, 01:47 PM
Hi guys,
I need help on creating a self-plotting spreadsheet that can also populate a number of days per month on its own depending on the year-month combination.
Example: if it is March 2016, there are 31 days according to the standard calendar
“Plotting of Shift” - Tab (see pic)
15680
“Shift Summary” - Tab (see pic)
15681
Below is a sample of the plotting of the names and their respective shifts: (I am aware of the Vlook up though… but the days of the month will be compromised if I used that, I need to re enter manually if I will use v-lookup)
(above: “Plotting of Shift” – Tab, Below: “Shift Summary” – Tab)
15682
Here are the sample files:
15683
Thanks and Regards,
pum
I need help on creating a self-plotting spreadsheet that can also populate a number of days per month on its own depending on the year-month combination.
Example: if it is March 2016, there are 31 days according to the standard calendar
“Plotting of Shift” - Tab (see pic)
15680
“Shift Summary” - Tab (see pic)
15681
Below is a sample of the plotting of the names and their respective shifts: (I am aware of the Vlook up though… but the days of the month will be compromised if I used that, I need to re enter manually if I will use v-lookup)
(above: “Plotting of Shift” – Tab, Below: “Shift Summary” – Tab)
15682
Here are the sample files:
15683
Thanks and Regards,
pum