birth day in advance

M

mangesh

hi,
i have a list of employees, i have put their birthdate in that list.
i want to know in 1 day advance the next birthday of the employees
 
F

Frank Kabel

Hi
one way would be to use conditional format:
- select the column of birthdates (lets say this is column B starting
in B1)
- goto 'Format - Conditional Format'
- enter the following formula
=DATE(YEAR(TODAY()),MONTH(B1),DAY(B1))=TODAY()+1
- select a format for these cells
 
Top