How to calculate the number of days until a birthday in Excel

To calculate the number of days until your birthday in Excel, follow the instructions below:

1. Highlight a cell A2 and enter your date of birth.
2. Highlight a cell B2 and enter the function TODAY (TODAY) to return today’s date.
3. The hardest part about calculating the number of days until your birthday is finding your next birthday. The formula below does the trick.

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

   =ДАТА(ГОД(A2)+РАЗНДАТ(A2;B2;"y")+1;МЕСЯЦ(A2);ДЕНЬ(A2))

   

   Explanation:

   • Function DATE (DATE) takes three arguments: year, month, and day.
   • We have used the function DATEDIF (RAZDAT) to find the number of full years (“y”) between the date of birth and today.
   • Formula RAZNDAT(A2; B2; “y”) returns the value 32.
   • If 32 full years have passed since your birthday (in other words, you have already celebrated your 32nd birthday), then on your next birthday you will celebrate the 32 + 1 = 33rd anniversary.
4. Next, we use the function DATEDIF (RAZDAT) to find the number of days (“d”) between the past and next birthday.

   =DATEIF(B2,C2,"d")

   =РАЗНДАТ(B2;C2;"d")