birth day in advance

  • Thread starter Thread starter mangesh
  • Start date Start date
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
 
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
 
Back
Top