Results 1 to 16 of 16

Problems with If logic for months. If this month, then.

Threaded View

  1. #1
    Registered User
    Join Date
    10-06-2014
    Location
    Greenville, SC
    MS-Off Ver
    2010
    Posts
    27

    Unhappy Problems with If logic for months. If this month, then.

    Good Day.

    I've been running in circles with this one.

    What I wish to accomplish is simple, yet it's leaving me perplexed.

    If January, then the number I have in another cell, and Feb through December should be 0. Then as the months tick off, Jan through the month chosen will be assigned a cell, and any months forward would be 0. For instance, if July is chosen as the current month, then c13=y4 and so on up till July, Aug through December would be 0 or "".

    If you need a further explanation, I can try to explain further. I don't have any hair left on this simple problem!
    Last edited by dceremuga; 07-31-2017 at 11:52 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Count how many dates are this month, 2 months and 3 months old
    By jimmisavage in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-21-2017, 09:21 AM
  2. Best logic to return TRUE in VBA if month NAMES are 1 apart?
    By dmasters4919 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-20-2015, 10:47 AM
  3. [SOLVED] VBA Insert Current Month, Year and subsequent months/year for 15 months
    By MichiganWilliams in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2014, 03:49 PM
  4. [SOLVED] Logic Problems
    By ravin13524666 in forum Excel General
    Replies: 6
    Last Post: 05-31-2013, 07:36 AM
  5. Macro using vlookups comparing 2 months paysheet(previous month and current month)
    By srinivasan1965 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-07-2012, 03:45 AM
  6. Replies: 1
    Last Post: 11-22-2011, 08:11 AM
  7. And(month,year) logic
    By dstan15 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2007, 11:20 AM

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