Silvermini63
Active Member
- Joined
- Sep 25, 2006
- Messages
- 293
Does anyone know a formula to calculate the months and days until your next birthday
format eg. 8 m 25 d
format eg. 8 m 25 d
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 |
Could be done in 1 formula, but I would add a helper cell to show the next birthday.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?
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 |