A birthday list Excel template is a worksheet for keeping names, birth dates, and useful reminder details together. In Microsoft Excel for Microsoft 365 on Windows, create one with columns for a person’s name and date of birth, then add a formula to show the next birthday and how many days away it is; the steps and sample formulas below make a simple list easy to maintain.
What a birthday list template is for
A birthday list is a small contact-planning spreadsheet, not a calendar replacement. It gives you one place to look up birthdays, sort a list, and prepare cards, messages, or events. A basic workbook can be a single sheet, while a family, club, or workplace list may need separate sheets or extra fields for preferences and planning.
The main benefit is consistency: dates are stored in a recognizable format rather than scattered through notes, messages, and calendar entries. Excel can sort real date values chronologically, filter a table by person or group, and calculate the next occurrence of a birthday. It cannot, by itself, send a notification when a date arrives. That distinction matters if you expect the spreadsheet to act like an alarm.
A template is most useful when its fields match the way you will actually use it. Someone tracking a few relatives may need only names and birthdays. An organization coordinating many people may also need a group, contact method, or reminder status. Avoid collecting details simply because there is room for them.
Useful columns to include
Start with a compact set of columns. Put one person on each row and use a single header row at the top. For example:
- Name: The name you will recognize when scanning or sorting the list.
- Birthday: The full birth date, including year if you have a clear reason to store it.
- Next birthday: A calculated date for the next occurrence, useful for sorting what is coming up.
- Days until: A calculated number that makes near-term birthdays easy to spot.
- Group or relationship: Optional labels such as family, friends, or team.
- Notes: Optional brief details, such as a preferred way to celebrate. Keep sensitive information out of this field.
For many personal lists, the year of birth is not necessary. You can store a date using a neutral placeholder year if you only care about month and day, but be consistent and make clear that the year is not reliable. If you need to calculate age or distinguish people with the same name, store the actual year only when appropriate. Do not assume everyone wants their full date of birth recorded.
Build the worksheet in Excel
Open a blank workbook and enter headers in row 1, for example Name, Birthday, Next birthday, and Days until. Enter each person on a separate row. In the Birthday column, type dates as dates rather than as text; a value such as 3/15/1990 is usually recognized as a date, though its display can depend on your regional settings. To make the entries easier to read, select the date column and choose Home > Number Format, then select a date format.
Turn the range into an Excel table so its headers have filter buttons and new rows can be included more consistently. Select a cell in the range and choose Insert > Table. Confirm that the range is correct and that “My table has headers” is selected. Give the table a descriptive name from the Table Design tab if you want to refer to it later. The tab appears when a table cell is selected.
Freeze the header row if the list is long: choose View > Freeze Panes > Freeze Top Row. You can also adjust column widths by double-clicking the boundary between column letters. These are small setup steps, but they make a growing list more usable on screen and when printed.
Calculate the next birthday
A birthday’s stored date is in the past for most of the year, so sorting that column alone will not show which celebration is coming next. Add a Next birthday column instead. With names in A2:A20, birth dates in B2:B20, and the next-birthday result in C2, enter this formula in C2:
=IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))<TODAY(),DATE(YEAR(TODAY())+1,MONTH(B2),DAY(B2)),DATE(YEAR(TODAY()),MONTH(B2),DAY(B2)))
Copy the formula down the column. It constructs this year’s birthday from the month and day in B2, then uses the following year if this year’s date has already passed. With today set to November 3, 2026, and B2 containing March 15, 1990, the result is March 15, 2027. Format column C as a date, then sort the table by Next birthday from oldest to newest to see the upcoming dates in order.
There is a leap-day detail to decide. Excel’s DATE function normalizes February 29 in a non-leap year to March 1. That makes the formula above treat a February 29 birthday as March 1 in years without a leap day. If the person or organization observes it on February 28 instead, use a manually agreed rule or maintain that date separately; do not assume a formula’s convention matches everyone’s preference.
Show how many days remain
A Days until column turns the next-birthday date into a simple countdown. With the same layout—next birthdays in C2:C20 and the count in D2—enter this formula in D2:
=C2-TODAY()
Copy it down. If C2 is November 15, 2026, and today is November 3, 2026, the result is 12 days. Format column D as General or Number, not as a date, because the formula returns a count of days. A result of zero means the birthday is today. TODAY updates when Excel recalculates the workbook, so the displayed count is not a fixed historical value.
If a row has no birthday entered, formulas may show an unhelpful date or number. The simplest prevention is to enter only complete rows and leave formula cells blank until a date is present. If blanks are common, with B2 as the birthday and C2 as the next-birthday cell, use this guarded version in C2:
=IF(B2="","",IF(DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))<TODAY(),DATE(YEAR(TODAY())+1,MONTH(B2),DAY(B2)),DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))))
This version leaves C2 empty when B2 is empty. Add the day-count formula only after the next-birthday column is populated, or use a similar blank check if empty rows are part of the list.
Make upcoming dates easier to notice
Sorting by Next birthday is usually the clearest way to find what is coming up. For a visual cue, select the Days until cells and use Home > Conditional Formatting > Highlight Cells Rules > Less Than. Enter a threshold such as 8 and choose a format. This highlights values from zero through seven, but it can also highlight negative values if any occur, so check that the next-birthday formula is correct and that the column contains numbers.
You can filter the table by group, such as showing only relatives or a particular team, using the dropdown arrow in the header. For a printed list, choose Page Layout to set orientation and margins, and use Print Preview to check that the names and dates fit. A spreadsheet is not a notification service: for an actual alert, add important dates to a calendar application that supports reminders. The Excel file can remain the master list, while the calendar provides the timed notification.
Privacy and sharing considerations
Birth dates can be personal information, especially when they include the birth year. Collect only what is needed, tell contributors how the list will be used, and limit access to people who need it. A shared birthday list for a team may need only month and day; storing full birth dates can create unnecessary exposure. Avoid putting account credentials, medical details, or other sensitive material in notes.
Excel worksheet protection can help prevent accidental edits, but it is not a substitute for limiting access to the file. Use the sharing permissions available in the storage location, and be cautious about emailing copies that may be saved or forwarded. Keep an unshared copy if appropriate, and remove outdated entries when they are no longer needed. If the workbook is used for a group, decide who is responsible for correcting mistakes and updating it.
Excel template versus calendar or contact app
An Excel template is a good fit when you want a sortable, customizable record and are comfortable updating it. It is particularly handy for lists with categories, notes, or a print-friendly view. A calendar app is generally better for notifications, recurring events, and invitations. A contacts app can be better if birthdays should stay attached to a person’s contact record and sync across devices.
You can use both: keep only the details needed in Excel, then enter selected birthdays into a calendar with an annual reminder. This avoids relying on a workbook that may not be open on the day. Be aware that manually maintaining two lists can create mismatches; choose one as the source of truth and periodically compare them. For a very short list, a calendar or contacts app alone may be simpler than a spreadsheet.
Common mistakes and quick fixes
- Dates sort strangely: Some entries may be text rather than date values, or the list may be sorted by Birthday instead of Next birthday. Re-enter or convert the inconsistent cells, then sort the calculated column.
- The formula shows a number: Excel stores dates as serial numbers. Apply a date format to Next birthday, but keep Days until in General or Number format.
- The countdown seems stale: TODAY changes when the workbook recalculates. Press F9 on Windows to recalculate; on a Mac, use Fn+F9 on keyboards where the function keys require Fn. Excel’s calculation settings can also affect when formulas update.
- The birthday appears one day off: Check regional date interpretation and confirm the cell contains the intended date. A typed date can be read differently under different locale settings.
- A leap-day date moved: Decide whether February 28 or March 1 is the intended non-leap-year observance and record that policy explicitly.
Frequently Asked Questions
Can Excel remind me about birthdays automatically?
Not just because a date is in a worksheet. Excel can calculate which birthdays are near and highlight them, but it does not automatically send a scheduled alert from a basic workbook. Use a calendar or reminder service for notifications.
Should I include the birth year?
Only if you need it, for example to calculate age or distinguish records. If the purpose is simply to remember annual birthdays, month and day may be enough. Consider privacy before storing full dates of birth.
How do I sort birthdays by the next date?
Add a Next birthday column using the formula above, format it as a date, and sort that column from oldest to newest. Sorting by the original birth-date column groups dates by year as well as month and day, which is usually not the desired upcoming order.
Can I use the template in Excel for Mac or Excel for the web?
The basic columns and formulas use standard Excel functions and work in Microsoft 365 versions that support them, including Mac and the web. Menu placement and keyboard shortcuts can differ, so use the visible Insert, View, and Home tabs if a Windows shortcut does not match your device.
What should I do if I only know the month and day?
Record the known information consistently and label any placeholder year so nobody mistakes it for a verified birth year. Do not use age calculations on placeholder dates. If precision matters, ask the person rather than guessing.
Related
- Excel Merge Two Cells With Text Without Losing Data
- Excel Lock Slicer in Place? Position and Protect It
- Excel Slicer: Connect One Slicer to Multiple PivotTables
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Merge Cells Command: Shortcuts, Options, and LimitsIn Excel for Microsoft 365 on Windows, select the cells you want to combine, then choose Home >…
- Excel Page Break View Without Page Numbers: What to DoIn Excel for Microsoft 365 on Windows, you cannot hide the large “Page 1,” “Page 2,” and similar…
- How to Find Unique Values in Google SheetsTo list distinct values without changing your source data, enter =UNIQUE(A2:A10) in an empty cell, replacing the range…
- Excel Merge Cells Button: Where It Is and How to Use ItIn Excel for Microsoft 365 on Windows, select the cells you want to combine, then choose Home >…
- Automate Text to Columns in Excel: Methods and LimitsYes—but Excel’s Text to Columns command does not automatically repeat itself whenever new data arrives. For a one-time…
- Create an Email Signature in Outlook: Step-by-StepTo create an email signature in Outlook, open the signature settings for your version, choose New, enter and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.