Finding next date in column

[TheGuy]

I have a spreadsheet with the names and birthdates of all employees i
our company.

Column A has the birthdates (dd-mon ie 18-jun) sorted by date
Column B has the names
C1 has todays date (=today())

What I'm trying to do is use a formula in C2 to display the nex
birthday. Any ideas

 

[Domenic]

*I have a spreadsheet with the names and birthdates of all employee
in our company.

Column A has the birthdates (dd-mon ie 18-jun) sorted by date
Column B has the names
C1 has todays date (=today())

What I'm trying to do is use a formula in C2 to display the nex
birthday. Any ideas? *

Hi,

try,

=VLOOKUP(MIN(IF(DATE(YEAR(TODAY()),MONTH(A2:A4),DAY(A2:A4))>=C1,A2:A4)),A2:B4,2,0)

Adjust the range to suit your spreadsheet and enter the formula usin
CTRL+SHIFT+ENTER

Hope this helps