How to find employee's birthday information in EXCEL table? . . . .

1, the computer opens the Excel table, and then lists the birthday data.

2. After listing the data, enter the formula =MONTH(A2) in the B2 cell.

3. Enter the formula = month (A2), and then press enter and drop down to get the birthday months of all employees.

4. After obtaining the birthday months of all employees, select the month column, and then click Filter.

5. Enter the filtering page and select the data of birthday in May.

6. After screening, you can get the information of all employees who have birthdays in May.