Days until Birthday

 

To calculate the number of days until your birthday in Excel, execute the following steps.

1. Select a cell and enter your date of birth.

2. Select the cell next to it and enter the TODAY function to return today's date.

Today

3. The most difficult part in order to get the number of days until your birthday is to find your next birthday. The formula below does the trick.

Next Birthday

Explanation: The DATE function accepts three arguments: year, month and day. We used the DATEDIF function to find the number of complete years ("y") between Date of Birth and Today. DATEDIF(A2,B2,"y") equals 32. If 32 complete years have passed since your date of birth (in other words, you have already celebrated your 32st birthday), your next birthday will be 32 + 1 = 33 years after your date of birth.

4. Next, we use the DATEDIF function to find the number of days ("d") between Today and Next Birthday.

Days until Birthday in Excel