+ Reply to Thread
Results 1 to 2 of 2

Problem to creating a calander

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    10-03-2012
    Location
    USA
    MS-Off Ver
    2010
    Posts
    496

    Problem to creating a calander

    Hi,
    I try to setup one calender, then use validation list for year and month.
    Then I use vlookup to find year and month then look for JanSun1 in cell B10.
    So B10=JanSun1

    Below is the working orginal formula to find the date on Sunday in January;
    The result is a blank.
    =IF(AND(YEAR(JanSun1)=$A$1,MONTH(JanSun1)=1),JanSun1, "")

    Once JanSun1 is substituted with B1,the formula does not work.
    =IF(AND(YEAR(B10)=$A$1,MONTH(B10)=1),B10, "")

    I press F9 to see B10, which shows "JanSun1" with quotation marks.
    I use value(B10) try to elimate the quotation mark, it does not work.

    Please advise. Thanks

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Problem to creating a calander

    Let me guess
    B10 should contain
    Formula: copy to clipboard
    =JanSun1
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

+ 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. VBA for Pop Up Calander
    By raxs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-16-2012, 05:32 AM
  2. Calander and clock!
    By Canuckbulldog in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-10-2007, 12:34 PM
  3. calander help
    By Brian in forum Excel General
    Replies: 1
    Last Post: 03-15-2006, 06:30 PM
  4. Error with calander
    By parteegolfer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2006, 01:20 AM
  5. [SOLVED] calander control and copy command problem
    By He4Giv in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-29-2005, 02:05 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