weekday() help please?

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
 
R

Ron Rosenfeld

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

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
 

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

Top