DATE/DATEDIF ==> Days upto next birthday

DATE/DATEDIF ==> Days upto next birthday

To calculate the number of days until your birthday in Excel,If you want to be live demo, download the Excel file.

 

Date of Birth      Today             Next Birthday           Days until Birthday
9/17/1981          2/14/2017         9/17/2017                      215
Next Birthday
=DATE(YEAR(A2)+DATEDIF(A2,B2,”y”)+1,MONTH(A2),DAY(A2))
Days until Birthday
=DATEDIF(B2,C2,”d”)

 

 

 

 

Share this post

Post Comment

15 + 10 =