weekday() help please?

  • Thread starter Thread starter Totti
  • Start date Start date
T

Totti

Hi all
i would like to find the fifth working day in a month, whatever this
month is and whenever it happens to start, after searching a solution
i found out that weekday() is what i need, i implemented it in my
worksheet but still i am lost on how to use it especially that i am
using it inside a match. would any one help please on how to implement
it correctly to find the 5th working day of a month?

Thanks in advance
 
Hi all
i would like to find the fifth working day in a month, whatever this
month is and whenever it happens to start, after searching a solution
i found out that weekday() is what i need, i implemented it in my
worksheet but still i am lost on how to use it especially that i am
using it inside a match. would any one help please on how to implement
it correctly to find the 5th working day of a month?

Thanks in advance
Click to expand...

Actually, WORKDAY is the function you want, assuming your workdays exclude Sat
and Sun (and, optionally, holidays).

Given some date in the month of interest in A1, the following will return the
5th working day in the month:

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

If you check HELP, you will note there is an optional Holiday list that you can
include in this function, so as to skip over holidays.
--ron
 
Back
Top