+ Reply to Thread
Results 1 to 4 of 4

Displaying a date only if the month is an even number

  1. #1
    Registered User
    Join Date
    04-15-2019
    Location
    glasgow, Scotland
    MS-Off Ver
    2007
    Posts
    2

    Displaying a date only if the month is an even number

    This one's been frying my head. I have a formula that displays a value from a cell (D12) if a date in a different cell (C12)falls before a date from a third cell (F2). That's the easy bit, what I want to do is to have the cell only display the value if the month in the second cell is an even number and to be blank if its an odd one. Is this possible and if so how? Thank in advance for any help, the formula I'm currently using is;

    =IF(C12<=F2,D12,"")

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,756

    Re: Displaying a date only if the month is an even number

    Take a look at seeing if you can modify this to your use?
    =iseven(MONTH(cell-ref))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    04-15-2019
    Location
    glasgow, Scotland
    MS-Off Ver
    2007
    Posts
    2

    Re: Displaying a date only if the month is an even number

    Thank you FDibbins, I added that formula to another cell, moved my original to F12 (and hid both of those cells) and used =IF((E12=TRUE),F12,"") in the cell I wanted the value in. So glad to finally have this working, thanks again for your help.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    49,756

    Re: Displaying a date only if the month is an even number

    Great stuff and thanks for the feedback and kind words

    You could have also used
    =IF(E12,F12,"")

    Also, maybe put the whole thing in 1 cell?
    =if(formula-in-E12,F12,"")

+ 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. Formula to give week number of a month according to date of the month
    By tukae in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-08-2016, 11:14 PM
  2. [SOLVED] Displaying every 1st and 15th of the month based on todays date
    By sprinter in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-03-2013, 12:41 PM
  3. displaying month to date data
    By RJDAl in forum Excel General
    Replies: 0
    Last Post: 06-13-2012, 09:22 PM
  4. Replies: 3
    Last Post: 09-25-2007, 10:26 AM
  5. Displaying previous month titles from one inputed date
    By jasonmcbride in forum Excel General
    Replies: 6
    Last Post: 08-03-2007, 01:47 AM
  6. Displaying only the month of a date...
    By firefiend in forum Excel General
    Replies: 5
    Last Post: 06-05-2007, 04:45 PM
  7. Date Format - converting number of month to name of month
    By Merlinwb in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 04-12-2005, 11:55 AM

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