+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Showing negative months

  1. #1
    Registered User
    Join Date
    02-28-2011
    Location
    Tallahassee, FL
    MS-Off Ver
    Excel 2007
    Posts
    2

    Showing negative months

    I am working with an excel spreadsheet where I'm showing the date a report was due vs. the date a report was actually completed. I want to use conditional formatting to show if a date is on time, 1 month behind, or 2+ months behind.

    I'm doing pretty well using =(MONTH(A2)-MONTH(A5))<=-2, be red. Where I have a problem is going back between years. So January 2010 - November 2009 is negative 2 (-2) but it shows up as #####. Is there a way I can subtract 01/2010 from 11/2009 and show a negative number?

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Showing negative months

    The simplest way would be to just count days, e.g. something like

    =A2-A5< 60

    of course 60 is an approximation of 2 months, would that be OK or do you actually want to increment by a month when you go from Feb to March etc.?
    Audere est facere

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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