Results 1 to 2 of 2

Thread: Max & If Array for Dates
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2016
    Posts
    43
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Max & If Array for Dates

    I'm scratching my head with this conundrum

    I have two similar reports that mine the same data which lists transactions.

    In my first report I have a column which shows the date of the last invoice raised to a customer:

    {=max(if(Retailer=A1,InvDate,"None"))}

    In my first report, if there have been no invoices raised to the customer then the cell is blank, which is what I want

    In my second report, the same formula returns 0 which then defaults to 00/01/1900 as a date. What am I missing?

    Thanks in advance for your feedback.

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    85,117
    Post Thanks / Like
    Mentioned
    44 Post(s)
    Tagged
    9 Thread(s)

    Default Re: Max & If Array for Dates

    If you have MAXIFS, you can switch to that function.

    Otherwise:

    {=IF(COUNTIFS(Retailer,A1,InvDate,">0"),MAX(if(Retailer=A1,InvDate)),"")}
    Assuming too much and qualifying too much are two faces of the same problem.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •