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
    Post Thanks / Like
    0 Post(s)
    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:


    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
    The Hague, NL
    Post Thanks / Like
    44 Post(s)
    9 Thread(s)

    Default Re: Max & If Array for Dates

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


    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