# How Many Days Until Mother's Day 2024?

## Time Remaining Until Mother's Day:

👩 May 12, 2024

26 days
• 3 weeks 5 days
• 624 hours

There are twenty-six days remaining until Mother's Day, which falls on May 12, 2024. This is calculated from today's date, which is April 16, 2024.

Mother's Day falls on the second Sunday of May every year.

The following chart shows the days remaining until Mother's Day from today and various other days.
On DateCountdown to Mother's Day 👩
April 12, 202430 days
April 13, 202429 days
April 14, 202428 days
April 15, 202427 days
April 16, 202426 days
April 17, 202425 days
April 18, 202424 days
April 19, 202423 days
April 20, 202422 days

## How Many Work Days Are Left Until Mother's Day?

### Weekdays Until Mother's Day

19 days

You can use our business days calculator to find how many working days are between any two dates.

It's important to note that this does not consider holidays that may fall on a weekday, such as Christmas. So, you'll need to adjust this to account for holidays that you do not work.

## How To Calculate the Days Until Mother's Day

You can count down the days until Mother's Day (5/12) in a few ways. The easiest is to use a calculator, such as our days until date calculator. You can also calculate the days manually or use a spreadsheet formula.

### Method One: Calculate the Days Manually

If the current date falls in May, then you can simply subtract the current day of the month from 12. The resulting value is the number of days remaining.

days until 5/12 = 12 – current day in May

If the current date is not in May, then you can subtract the current day of the month from the number of days in the current month to find the remaining days in that month. Then, to that value, you can add the number of days in each month before May, and then add 12 for the number of days in May.

days until 5/12 = days left in the current month + days in next month + … + 12

### Method Two: How To Calculate the Days Using Google Sheets

You can also calculate the number of days remaining until 5/12 using spreadsheet software such as Google Sheets or Microsoft Excel. You can do this using a few different formulas.

### From the Current Date

If you want to find the number of days remaining from the current day, you can use the following function in a cell to calculate that number:

=DATE(2024, 5, 12) - TODAY()

Note that this formula calculates and displays the number of days once you type the formula into a cell and hit Enter.

### From Any Date

If you want to find the number of days remaining from a specific date listed in another cell, in this case, from a date in cell A1, then you can use the following function to display the number of days remaining from the date displayed in cell A1:

=DATE(2024, 5, 12) - A1