---
title: "Birthday Tracking in Excel"  
description: "Birthday Tracking in Excel"  
author: "AVADHESH PATEL"  
published: 2013-03-25  
updated: 2019-09-07  
canonical: https://www.mindstick.com/articles/1165/birthday-tracking-in-excel  
category: "excel"  
tags: ["excel"]  
reading_time: 1 minute  

---

# Birthday Tracking in Excel

Excel date [functions](https://www.mindstick.com/forum/34086/jquery-callback-functions) and formulas can help you manage date [related data](https://www.mindstick.com/interview/22990/what-is-lazy-eager-and-explicit-loading-of-related-data-in-entity-frameworks) and to [transform](https://www.mindstick.com/interview/511/what-are-the-steps-to-transform-xml-into-html-using-xsl) boring looking data into [meaningful](https://yourviews.mindstick.com/story/1909/6-meaningful-ways-to-celebrate-christmas-this-year) graphs. This [article](https://yourviews.mindstick.com/view/81489/kashmir-now-after-an-year-of-abrogation-of-article-370) will tell you four very [simple](https://www.mindstick.com/blog/63525/get-the-most-out-of-maths-with-these-8-simple-tricks) date functions and how to use them using birthday tracking example.\

First, create an [excel sheet](https://www.mindstick.com/forum/23040/to-import-excel-sheet-into-sql-database) with some dummy data as below [image](https://www.mindstick.com/articles/23551/an-investigate-distinctive-seafood-restaurant-for-your-image-stamp-character).

##### Figure 1:

![Birthday Tracking in Excel](https://www.mindstick.com/mindstickarticle/79a3b579-fe5d-4d91-ad13-32341ff10a51/images/676c8e34-1036-42ca-ac63-e8baf515f744.png)

Now, Steps are given below

Steps 1: First calculate Current month into current Month column using TODAY function as below

=MONTH(TODAY())

##### Figure 2:

![Birthday Tracking in Excel](https://www.mindstick.com/mindstickarticle/79a3b579-fe5d-4d91-ad13-32341ff10a51/images/dee35431-d869-4b73-b7c5-3bba97f260e5.png)

Step 2: Now calculate [Employee](https://www.mindstick.com/articles/178134/how-to-write-the-best-welcome-letter-for-new-employees)’s birthday month as below

=MONTH([@DOB])

##### Figure 3:

![Birthday Tracking in Excel](https://www.mindstick.com/mindstickarticle/79a3b579-fe5d-4d91-ad13-32341ff10a51/images/8f4e7fc4-0d2b-43ff-8311-4f086b4037c4.png)

Step 3: Now check birthday month with current moth. If “Current month” value equal to “Month of Birth” then return yes as alert in “Alert” column as below image

=IF([@[Current Month]]=[@[Month of Birth]],"yes","")

##### Figure 4:

![Birthday Tracking in Excel](https://www.mindstick.com/mindstickarticle/79a3b579-fe5d-4d91-ad13-32341ff10a51/images/8afddc96-cfe9-429e-9cd4-c6723540c919.png)

Hence, [Figure](https://yourviews.mindstick.com/view/87536/what-are-ghosts-jobs-and-how-to-figure-out-them) 4 display, two person’s birthday.

---

Original Source: https://www.mindstick.com/articles/1165/birthday-tracking-in-excel

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.