+ Reply to Thread
Results 1 to 7 of 7

Poor mans calendar

  1. #1
    Registered User
    Join Date
    08-24-2012
    Location
    Schiedam, holland
    MS-Off Ver
    Excel 2003-2013
    Posts
    38

    Poor mans calendar

    Hi Guys,
    I need your expertise on completing my poor mans calendar. Enclosed is excel file with description of what I intended doing. Thanks in advance for your helping hand.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Wageningen, The Netherlands
    MS-Off Ver
    365
    Posts
    495

    Re: Poor mans calendar

    For #1: select B5:AF5 and set Conditional Formatting with this formula:
    =LEFT(B4;1)="z"
    and set the formatting

    do the same for the other rows

    BTW never heard of Scheidam


    Edited after i discovered the scroll down
    Last edited by L-Drr; 09-19-2013 at 09:19 AM.
    When I say semicolon, u say comma!

  3. #3
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Wageningen, The Netherlands
    MS-Off Ver
    365
    Posts
    495

    Re: Poor mans calendar

    For #2: you're asking how to eliminate 29, 30 and 31 if the CORRESPONDING YEAR doesn't have the dates... months ALWAYS have a certain number of days, regardless of the year... except for of course February, but you're not asking for day 28... so I'd say just manually remove those cells the have non-existing dates

  4. #4
    Registered User
    Join Date
    09-04-2013
    Location
    Seattle, WA, USA
    MS-Off Ver
    Excel 2013, Excel 2016
    Posts
    10

    Re: Poor mans calendar

    This solves your Conditional Formatting question. I do not understand the other parts. Please explain them in more detail in a post (not in an attachment).

    QkLyeuY.png
    Get Excel tips and tutorials at ExcelTactics.com

  5. #5
    Forum Contributor
    Join Date
    08-02-2013
    Location
    Wageningen, The Netherlands
    MS-Off Ver
    365
    Posts
    495

    Re: Poor mans calendar

    shadrack's point #2 "zie uitwerking" means see the sheet called "uitwerking"
    in #3 the question is how to edit the COUNTA for "z" but only count a value like "z 1/2" als 0.5, so that [z|z|z 1/2] would count as 2.5

  6. #6
    Registered User
    Join Date
    08-24-2012
    Location
    Schiedam, holland
    MS-Off Ver
    Excel 2003-2013
    Posts
    38

    Re: Poor mans calendar

    Thanks to all the problem is solved. Specially to L-Drr for showing me how to describe my problems and not forgetting spelling error correction to my location.

  7. #7
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Poor mans calendar

    As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.

    Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Calendar entry meeting in lotus notes calendar with macro
    By abjac in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-16-2016, 05:45 AM
  2. Calendar functions - linking work activities with formatted dates to calendar
    By SKSS in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 05-14-2012, 06:38 PM
  3. Calendar VBA auto filling week and month based on calendar entry.
    By perrymagic in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-18-2011, 02:00 PM
  4. Replies: 0
    Last Post: 10-31-2011, 10:58 PM
  5. Replies: 0
    Last Post: 03-27-2008, 04:36 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1