First Business day of the month?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

Is there a quick way to find the first business day of the month? I could
find it using a loop in conjuction with the Weekday function. But I was
wondering if there is a more concise and elegant approach. Thanks for
sharing your thoughts.

Ben

--
 
Try =workday(DATE(2005,11,0),1)

where 11 is the month number.

WORKDAY is part of the Analysis Toolpak, so that needs to be installed.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Hi all,

Is there a quick way to find the first business day of the month? I could
find it using a loop in conjuction with the Weekday function. But I was
wondering if there is a more concise and elegant approach. Thanks for
sharing your thoughts.

Ben
Click to expand...

With some date of the month in A1:

=WORKDAY(A1-DAY(A1),1)

will do it as a worksheet function, provided you have the Analysis Tool Pack
installed. The ATP can also be used in a VBA routine.

Without ATP, note that, where Dt=some date in a month,

Dt-Day(Dt)

will always be the last day of the previous month. You could then loop through
weekends and optionally also through Holidays.


--ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lousy routine to get the first available day of the month 2
code snippets 1
a quick way to determine the first and last biz date of the month 3
Excel Message box with days of month & date. 1
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Calculate Payment Days and Date 3
Day of the week 1
Date formats change (code included) 9

Back
Top