How to calculate days until next birthday in Excel?

If you want to know how many days remain until your next birthday, how would you do it? Actually, if you are using Microsoft Excel, you can use formulas in the worksheet to easily count the days until next birthday. Please browse for more details as below tutorial shows.

Count days until next birthday with formulas

Count days until next birthday with formulas

For counting days until next birthday with formulas, please do as follows.

Step 1. Create a worksheet with headers showing below

In a worksheet, create column headers consecutively as below screenshot shows. And type your date of birthday into the cell A2 under the Date of birthday header.

Step 2. Get today’s date

Now we need to get Today’s date with formula. Select cell B2, enter the formula below, and press Enter.

=TODAY()

This will display today's date in cell B2.

Step 3. Get the date of next birthday

Select cell C2, copy or enter the formula below, and press Enter.

=DATE(YEAR(A2)+DATEDIF(A2,B2,"y")+1,MONTH(A2),DAY(A2))

Step 4. Get the remaining days until next birthday

Select cell D2, enter the formula below, then press Enter.

=DATEDIF(B2,C2,"d")

Then you will get the remaining days until next birthday in cell D2.

Note: Besides the above formulas, there is also another formula that can help. Please enter your birth date into a blank cell, A1 for example, and then type following formula: =IF(A1,DATE(YEAR(A1)+DATEDIF(A1+1,TODAY(),"y")+1,MONTH(A1),DAY(A1))-TODAY(),""), and then press Enter key to get the remaining days until next birthday.