creating a calender

jquerry

New Member
Joined
Jul 7, 2012
Messages
4
I am looking for some advice on creating a calender in excel that will read text dates in a spreadsheet and then transpose them into a calender. For example corporate has provided a list of 200+ employees by name and the corresponding vacation request days (see below for format). I would like for another spreadsheet in another tab to apply those dates into a calender and then have a conditional format for overlapping dates to change color.
NAME (LAST,FIRST_MI)EMP IDLOCATIONTDY LOCATIONSTATUSR&R DEPART (D/MM/YR)R&R RETURN (D/MM/YR)
Snuffy, Joe 25-Nov-1315-Dec-13

<colgroup><col style="width: 192pt; mso-width-source: userset; mso-width-alt: 9362;" width="256"> <col style="width: 46pt; mso-width-source: userset; mso-width-alt: 2230;" width="61"> <col style="width: 122pt; mso-width-source: userset; mso-width-alt: 5924;" width="162"> <col style="width: 76pt; mso-width-source: userset; mso-width-alt: 3693;" width="101"> <col style="width: 71pt; mso-width-source: userset; mso-width-alt: 3437;" width="94"> <col style="width: 77pt; mso-width-source: userset; mso-width-alt: 3766;" width="103"> <col style="width: 83pt; mso-width-source: userset; mso-width-alt: 4059;" width="111"> <tbody>
</tbody>
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Snakehips

Well-known Member
Joined
May 17, 2009
Messages
5,069
Office Version
  1. 2013
Platform
  1. Windows
jquerry,

Maybe this small scale example will help you on your way..

I have included a marker whick you can use to show conflict within a given status. If that is not required then make the marker for all employees say H and it will highlight conflict regardless of status.

Excel Workbook
ABCDEFGHIJKLMNOPQRS
1NameIDLocTDY LocStatusMarkerDepartReturn1-Jan2-Jan3-Jan4-Jan5-Jan6-Jan7-Jan8-Jan9-Jan10-Jan
2Snuffy, JoeSupervisorS03/01/201305/01/2013 SSS
3Smith, JohnOffice WallahOW06/01/201308/01/2013OWOWOW
4Soap ,JoeOffice WallahOW08/01/201309/01/2013OWOW
5Contrary, MarySupervisorS01/01/201303/01/2013SSS
6Doe, JaneOffice WallahOW03/01/201305/01/2013OWOWOW
Sheet1
Cells with Conditional Formatting
CellConditionCell FormatStop If True
J21. / Formula is =AND(J$1>=$G2,J$1<=$H2)Abc
J22. / Formula is =AND(J$1>=$G2,J$1<=$H2)Abc


Hope that hgelps.
 

Watch MrExcel Video

Forum statistics

Threads
1,122,910
Messages
5,598,813
Members
414,260
Latest member
joishe

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top