Months and Days Until Next Birthday

[Silvermini63]

Does anyone know a formula to calculate the months and days until your next birthday

format eg. 8 m 25 d

 

[Peter_SSs]

For Excel versions before Excel 2007, you will need to have Analysis Toolpak installed and activated (check in Tools|Add-Ins...) to use the DATEDIF function.

Excel Workbook
	A	B	C
1	Next Birthday	Today	Until Next Birthday
2	15/03/2009	24/11/2008	3 m 19 d
Next Birthday

 

[Silvermini63]

Thanks for that, but would there also be away to do it where it can calculate it from your birthday e.g 3/05/1974 would still be 5 m 10 d?

 

[Peter_SSs]

Thanks for that, but would there also be away to do it where it can calculate it from your birthday e.g 3/05/1974 would still be 5 m 10 d?

Could be done in 1 formula, but I would add a helper cell to show the next birthday.

Excel Workbook
	A	B	C	D
1	Birthday	Today	Next Birthday	Until Next Birthday
2	03/05/1974	24/11/2008	03/05/2009	5 m 9 d
Next Birthday

 

[Silvermini63]

thank you very much for you help