Remaining days to birthday from today

This tutorial shows how to calculate the remaining days to a birthday, based on a birthdate, from today in Excel

Excel

EXCEL FORMULA 1. Remaining days to birthday from today

EXCEL

=IF(TODAY()<DATE(YEAR(TODAY()),MONTH(B5),DAY(B5)),DATE(YEAR(TODAY()),MONTH(B5),DAY(B5))-TODAY(),DATE(YEAR(TODAY())+1,MONTH(B5),DAY(B5))-TODAY())

GENERIC FORMULA

=IF(TODAY()<DATE(YEAR(TODAY()),MONTH(birthdate),DAY(birthdate)),DATE(YEAR(TODAY()),MONTH(birthdate),DAY(birthdate))-TODAY(),DATE(YEAR(TODAY())+1,MONTH(birthdate),DAY(birthdate))-TODAY())

ARGUMENTS
birthdate: The date of birth.

EXPLANATION
This formula uses the actual date of birth to calculate the number of days remaining until the next birthday. It uses a combination of multiple functions to initially identify which year the next birthday falls on and then identifies the number of days between today's date and the date of next birthday.

RELATED TOPICS

Related Topic	Description	Related Topic and Description
Remaining days to New Year from a specific date	How to convert a date of birth to age, in years in Excel
Remaining days to New Year from today	How to calculate the remaining days from today to New Year in Excel
Convert birthday to age in days	How to convert a date of birth to age, in days

RELATED FUNCTIONS

Related Functions	Description	Related Functions and Description
DATE Function	The Excel DATE function returns a date through the use of individual year, month and day parameters
YEAR Function	The Excel YEAR function returns the year from a specified date
DAY Function	The Excel DAY function returns the day from a specified date
TODAY Function	The Excel TODAY function returns the current date
IF Function	The Excel IF function performs a test on specified conditions entered into the formula and returns a specified value if the result is TRUE or another specified value if the result is FALSE
MONTH Function	The Excel MONTH function returns the month from a specified date