Results 1 to 3 of 3

creating a calender

This is a discussion on creating a calender within the Excel Questions forums, part of the Question Forums category; I am looking for some advice on creating a calender in excel that will read text dates in a spreadsheet ...

  1. #1
    New Member
    Join Date
    Jul 2012
    Posts
    4

    Default creating a calender

    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 ID LOCATION TDY LOCATION STATUS R&R DEPART (D/MM/YR) R&R RETURN (D/MM/YR)
    Snuffy, Joe 25-Nov-13 15-Dec-13

  2. #2
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092

    Default Re: creating a calender

    Microsoft MVP - Excel

  3. #3
    Board Regular Snakehips's Avatar
    Join Date
    May 2009
    Location
    Coventry UK
    Posts
    4,538

    Default Re: creating a calender

    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.

    Sheet1

     ABCDEFGHIJKLMNOPQRS
    1NameIDLocTDY LocStatusMarkerDepartReturn 1-Jan2-Jan3-Jan4-Jan5-Jan6-Jan7-Jan8-Jan9-Jan10-Jan
    2Snuffy, Joe   SupervisorS03/01/201305/01/2013   SSS     
    3Smith, John   Office WallahOW06/01/201308/01/2013      OWOWOW  
    4Soap ,Joe   Office WallahOW08/01/201309/01/2013        OWOW 
    5Contrary, Mary   SupervisorS01/01/201303/01/2013 SSS       
    6Doe, Jane   Office WallahOW03/01/201305/01/2013   OWOWOW     

    Spreadsheet Formulas
    CellFormula
    J2=IF(AND(J$1>=$G2,J$1<=$H2),$F2,"")

    Conditional formatting
    CellNr.: / ConditionFormat
    J21. / Formula is =AND(J$1>=$G2,J$1<=$H2)Abc
    J22. / Formula is =AND(J$1>=$G2,J$1<=$H2)Abc


    Excel tables to the web >> Excel Jeanie Html" target="_blank"> Excel Jeanie HTML 4

    Hope that hgelps.
    Tony

    AbUsing Excel 2002 to 2013
    This line will be updated just as soon as I come up with something, original, witty, profound or interesting. Please don't hold your breath!

    Please remember - we cannot see your workbook nor read your mind.
    Help us to help you, post clear detail of what you have and what you want - from the start.

    A screen shot can save a thousand words!
    Post a screen shot with one of these: Excel Jeanie, MrExcel HTML Maker
    If posting VBA code, please use Code Tags - see: here

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com