+ Reply to Thread
Results 1 to 2 of 2

Placing character under a month and year when the month falls between two dates

  1. #1
    Registered User
    Join Date
    07-02-2017
    Location
    Wellington, New Zealand
    MS-Off Ver
    2010
    Posts
    2

    Placing character under a month and year when the month falls between two dates

    I am attempting to work out which months fall between two dates. The columns have mmm-yyyy and the dates I am looking at start and end on different dates and years.

    I am wanting to place an X in the month columns that reflect what months occurred between the two dates.

  2. #2
    Registered User
    Join Date
    07-02-2017
    Location
    Wellington, New Zealand
    MS-Off Ver
    2010
    Posts
    2

    Re: Placing character under a month and year when the month falls between two dates

    This is the formula I have been using with no luck
    =IF(AND(COLUMNS($P1:P1)>=MONTH($G2),COLUMNS($P1:P1)<=MONTH($H2)),"X","")

+ 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] Is there a way to insert all dates for a month weekly when user inputs Month and a Year?
    By uniqbboy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2014, 10:40 AM
  2. Graphing dates by month/year with 2 bars per month/year
    By Ellpoyohlokoh in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-22-2014, 05:25 AM
  3. find time left in month.days unit between two dates(in YEAR.MONTH.DAY)
    By xcfeng95 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 02-21-2014, 12:55 PM
  4. Replies: 2
    Last Post: 12-01-2012, 03:06 PM
  5. [SOLVED] count if date in another cell falls in certain month and year
    By ea223 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-18-2012, 07:17 PM
  6. count no. of dates in a column that falls on certain month & year
    By RawSugar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-20-2005, 06:05 PM

Tags for this Thread

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