«
»

I would like to have a birthday reminder in excel. How to create?

I have my employees date of birth datas in excel as ……10/06/1978. I would like to have a birthday reminder from excel. How to create? Pls help.

There are many ways to handle this. It all depends on how sophisticated you want it to be. And it would have helped to know which version of MS-Excel you are using.

It could be something as simple as establishing Conditional Formatting to "highlight" the birthdays which are within a specific range of the current computer date:

1. Select the column with all of the Birth Dates.
2. Go to the menu selection of FORMAT ==> CONDITIONAL FORMATTING…
3. Change the Condition 1 box to say "Formula Is".
4. In the next box, paste the following formula:
= AND( A1 >= ( TODAY() – 10 ), A1 <= ( TODAY() + 10 ) )
5. Click the Format… button and go to the Patterns tab.
6. Select a background color that will indicate those birthdays which will fall within the specified date range.
7. Click the OK button twice to save those changes.

The above formula only flags those dates that are between 10 days before the current date through 10 days past the current date. (Modify the values to suit yourself.)

.

2 Responses to “I would like to have a birthday reminder in excel. How to create?”

  1. arti b Says:
    August 21st, 2009 at 7:37 am

    why not try birthdayalarm.com
    References :

  2. Jim Lee Says:
    August 21st, 2009 at 7:56 am

    There are many ways to handle this. It all depends on how sophisticated you want it to be. And it would have helped to know which version of MS-Excel you are using.

    It could be something as simple as establishing Conditional Formatting to "highlight" the birthdays which are within a specific range of the current computer date:

    1. Select the column with all of the Birth Dates.
    2. Go to the menu selection of FORMAT ==> CONDITIONAL FORMATTING…
    3. Change the Condition 1 box to say "Formula Is".
    4. In the next box, paste the following formula:
    = AND( A1 >= ( TODAY() – 10 ), A1 <= ( TODAY() + 10 ) )
    5. Click the Format… button and go to the Patterns tab.
    6. Select a background color that will indicate those birthdays which will fall within the specified date range.
    7. Click the OK button twice to save those changes.

    The above formula only flags those dates that are between 10 days before the current date through 10 days past the current date. (Modify the values to suit yourself.)

    .
    References :

Leave a Reply