How to find the first business day of the month in Excel

See it work

The formula is already in B2, filled down to B7. Change any input and the result updates, or edit the formula to experiment.

How it works

In Google Sheets

The same formula works in Google Sheets: =WORKDAY(EOMONTH(A2,-1),1,$D$2:$D$3). We ran it in Google Sheets mode on the same data and it returns the same results.

Other ways to do it

Each one was run on the same example sheet.

Common mistakes

• Starting from the 1st, WORKDAY(EOMONTH(A2,-1)+1,1), skips the 1st even when it is a working day.
• Keep the holiday list current; it needs next year's dates too.

Try it yourself

Same data, empty answer cell. Your formula is graded instantly, then re-checked on changed data, so a typed-in number won't pass.

Related answers

• How to find the last business day of the month in ExcelGo to the first day of next month and step back one working day: =WORKDAY(EOMONTH(A2,0)+1,-1,holidays).
• How to add business days to a date in ExcelUse =WORKDAY(start, days, holidays). It skips Saturdays, Sundays and every date in the holiday list.
• How to add months to a month-end date and stay at the end of the month in ExcelUse =EOMONTH(A2,B2). It adds the months and always returns the last day of the resulting month.
• How to calculate a due date with Net 30 end-of-month terms in ExcelStart the count at the end of the invoice month: =EOMONTH(B2,0)+30.
• How to calculate a project end date from a duration in working days in ExcelCount the duration minus one working day from the start: =WORKDAY(B2,C2-1,holidays), so the start day counts as day 1.
• How to calculate how many days of a date range fall in each month in ExcelOverlap the range with each month: =MAX(0,MIN($B$2,EOMONTH(D2,0))-MAX($B$1,D2)+1), with the month's first day in D2.

Functions used: WORKDAY · EOMONTH

Lessons: EDATE, EOMONTH & NETWORKDAYS (Pro)