+ Reply to Thread
Results 1 to 9 of 9

Formatting cells based on this and future months.

  1. #1
    Registered User
    Join Date
    05-11-2020
    Location
    Edmonton, Alberta
    MS-Off Ver
    365
    Posts
    8

    Formatting cells based on this and future months.

    I am trying to format cells when the month in the date is equal to or grater than the month in todays' date.
    I can do it by using month only formula, but then it also highlights the dates in years past. I want to high light only for yeas going forward.
    This is the formula i have so far build. But it does not seem to to work.

    ="(Year($D2)MONTH($D2))=MONTH(TODAY( ))"

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,978

    Re: Formatting cells based on this and future months.

    Welcome to the forum.

    What exactly do you mean by future months?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  3. #3
    Registered User
    Join Date
    05-11-2020
    Location
    Edmonton, Alberta
    MS-Off Ver
    365
    Posts
    8

    Re: Formatting cells based on this and future months.

    Months that are still to occur. My spreadsheets looks at dates in he future and in the past. But when i use a formula that looks at eh months, it also highlights months in the past years.

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,978

    Re: Formatting cells based on this and future months.

    So why are you not just simply looking at dates in the future? I donít get the reason why you are using months at all.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,978

    Re: Formatting cells based on this and future months.

    Maybe this?

    =D2>EOMONTH(TODAY(),0)

  6. #6
    Registered User
    Join Date
    05-11-2020
    Location
    Edmonton, Alberta
    MS-Off Ver
    365
    Posts
    8

    Re: Formatting cells based on this and future months.

    That is what I initially thought as well, but our production teams look at exact dates, but the accountants go by month, even if the days have already past.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,978

    Re: Formatting cells based on this and future months.

    Maybe this, then:

    =D2>EOMONTH(TODAY(),-1)+1

    This will highlight any date this month and beyond. Today it will include June, tomorrow it wonít.

  8. #8
    Registered User
    Join Date
    05-11-2020
    Location
    Edmonton, Alberta
    MS-Off Ver
    365
    Posts
    8

    Re: Formatting cells based on this and future months.

    OK, that works. Thanks.

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    41,978

    Re: Formatting cells based on this and future months.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

+ 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] Sum values of future months
    By juriemagic in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-10-2017, 02:59 AM
  2. Replies: 5
    Last Post: 04-09-2014, 08:13 AM
  3. Forecasting across future months
    By Dave.Oz in forum Excel General
    Replies: 1
    Last Post: 04-04-2014, 11:18 AM
  4. [SOLVED] Conditional Formatting based on calculated future dates (month only, ignore day and year)
    By Nitsirk82 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-27-2014, 06:42 PM
  5. Ignore Months In The Future
    By xybadog in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-28-2014, 07:06 AM
  6. Estimate next months based on historic & future target
    By Pyogenesis in forum Excel General
    Replies: 1
    Last Post: 01-11-2011, 07:00 AM
  7. [SOLVED] Networkdays & future months
    By denise in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-01-2006, 07:35 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