# How to calculate the first of the month after 60 days in Excel

Add the waiting period, go to that month's end and add a day: `=EOMONTH(B2+$F$1,0)+1`, with 60 in F1.

**Excel:** `=EOMONTH(B2+$F$1,0)+1` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C | D | E | F |
| --- | --- | --- | --- | --- | --- |
| Employee | Hire date | Benefits start |  | Waiting period (days) | 60 |
| A. Rivera | 2026-01-05 |  |  |  |  |
| J. Park | 2026-02-16 |  |  |  |  |
| L. Gomez | 2026-03-02 |  |  |  |  |
| D. Smith | 2026-06-30 |  |  |  |  |
| K. Ito | 2026-11-10 |  |  |  |  |

Formula in C2, filled to C6: `=EOMONTH(B2+$F$1,0)+1`

Result: 4/1/2026; 5/1/2026; 6/1/2026; 9/1/2026; 2/1/2027

## How it works

`B2+$F$1` is the day the waiting period ends. EOMONTH moves to the last day of that month, and +1 gives the first of the following month. A. Rivera's 60 days end on March 6, so benefits start April 1. Keeping 60 in a cell lets you switch to 30 or 90 days.

## Other ways

- `=DATE(YEAR(B2+$F$1),MONTH(B2+$F$1)+1,1)`: Builds the first of the next month from the parts.
- `=EOMONTH(B2+$F$1-1,0)+1`: Counts the hire date as day 1 of the waiting period. (L. Gomez starts May 1.)

## Common mistakes

- Check your plan's wording. "First of the month after 60 days" and "on or after day 60" differ when the period ends on the 1st, as it does for L. Gomez.
- `=EDATE(B2,2)` is two calendar months, not 60 days, and lands on the same day of the month rather than the 1st.

## Questions

**How do I get the first of the month after the hire date?**

`=EOMONTH(B2,0)+1`.

**How do I use 90 days instead?**

Put 90 in F1, or write `=EOMONTH(B2+90,0)+1`.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/first-of-the-month-after-60-days