weekday() help please?
 

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

weekday() help please?
 

On Mon, 27 Oct 2008 05:39:10 -0700 (PDT), Totti
wrote:

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

weekday() help please?
 

Ron Thanks a lot , it works great!!

thank you

weekday() help please?
 

On Tue, 28 Oct 2008 07:57:22 -0700 (PDT), Totti
wrote:

Ron Thanks a lot , it works great!!

thank you

You're welcome. Glad to help. Thanks for the feedback.
--ron