+ Reply to Thread
Results 1 to 10 of 10

function tell who in this month of this year Expiry

Hybrid View

  1. #1
    Registered User
    Join Date
    05-15-2016
    Location
    London
    MS-Off Ver
    2007
    Posts
    20

    function tell who in this month of this year Expiry

    hi everyone,
    i try to show who's name staff will Expiry in this month of this year (June,2016) from table =today()
    Thank you.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    12-22-2015
    Location
    Huntsville, AL
    MS-Off Ver
    2007
    Posts
    92

    Re: function tell who in this month of this year Expiry

    How's the attached?
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    05-15-2016
    Location
    London
    MS-Off Ver
    2007
    Posts
    20

    Re: function tell who in this month of this year Expiry

    hello
    I want only in yellow table show name staff like this function but I don't know how
    =IFERROR(INDEX(B3:B17;SMALL(IF(YEAR(B1)=YEAR(J3:J17)*(MONTH(B1)=MONTH(J3:J17));ROW(B3:B17)-1;"");ROW()-10));"")

  4. #4
    Registered User
    Join Date
    12-22-2015
    Location
    Huntsville, AL
    MS-Off Ver
    2007
    Posts
    92

    Re: function tell who in this month of this year Expiry

    Like this?
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    05-15-2016
    Location
    London
    MS-Off Ver
    2007
    Posts
    20

    Re: function tell who in this month of this year Expiry

    but it's not like that, can fix this function
    =IFERROR(INDEX(B3:B17;SMALL(IF(YEAR(B1)=YEAR(J3:J17)*(MONTH(B1)=MONTH(J3:J17));ROW(B3:B17)-1;"");ROW()-10));"")
    function.jpg

  6. #6
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,429

    Re: function tell who in this month of this year Expiry

    I propose the following formula.
    Formula: copy to clipboard
    =IF(AND(MONTH(J3)=MONTH(B$1),YEAR(J3)=YEAR(B$1)),B3,"")

    Enter N3 in cell and pull down.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    05-15-2016
    Location
    London
    MS-Off Ver
    2007
    Posts
    20

    Re: function tell who in this month of this year Expiry

    thanks for help all i want show formula like how i want it i find it in this sheet but a problem how i used in my sheet! if can put this formula in my sheet, thanks
    Attached Files Attached Files

  8. #8
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,429

    Re: function tell who in this month of this year Expiry

    See more variants.
    Attached Files Attached Files

  9. #9
    Forum Expert
    Join Date
    12-09-2014
    Location
    Trakai, Lithuania
    MS-Off Ver
    2016
    Posts
    1,429

    Re: function tell who in this month of this year Expiry

    See more variants in accordance with the post №7.
    Attached Files Attached Files

  10. #10
    Registered User
    Join Date
    05-15-2016
    Location
    London
    MS-Off Ver
    2007
    Posts
    20

    Re: function tell who in this month of this year Expiry

    Thank you so much, Czeslaw & cdubisms, Everything is working perfectly now. Thanks for your time and effort.

+ 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. Running Totals from 24 hours to month, month to year without year decreasing
    By Safetyintern in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-20-2015, 01:13 PM
  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. Replies: 3
    Last Post: 09-04-2013, 10:49 AM
  4. If Column A Month and Year = ColumnB Todays Month and Year then send email
    By HACCStaff in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-15-2013, 12:47 AM
  5. Using Month & Year Function Together
    By dianamay in forum Excel General
    Replies: 2
    Last Post: 02-09-2011, 10:48 PM
  6. Using the IF function:value with the month and year
    By jonnyp in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-29-2008, 10:43 AM
  7. [SOLVED] Month/ year function.
    By Houm in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 04-05-2005, 09:06 PM

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