none
Excel Function RRS feed

  • Question

  • Is it possible to find out the next birthday in a list of birthday dates without using macro in excel.
    Friday, March 29, 2019 1:50 AM

All replies

  • Assuming that you have a list of birthdays sorted in ascending order in A2:A100, the next birthday to occur after today's date is given by

    =INDEX(A2:A100,MATCH(TODAY(),A2:A100)+1)


    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Friday, March 29, 2019 12:21 PM