To calculate the number of days until your birthday in Excel, follow the instructions below:
- Highlight a cell A2 and enter your date of birth.
- Highlight a cell B2 and enter the function TODAY (TODAY) to return today’s date.
- 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.
- 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")
