Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
weekday() help please?
Ron Thanks a lot , it works great!!
thank you |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
WEEKDAY() function: display TEXT not numeric weekday | Excel Discussion (Misc queries) | |||
WEEKDAY() | New Users to Excel | |||
Weekday | Excel Worksheet Functions | |||
Weekday | Excel Discussion (Misc queries) | |||
WEEKDAY using IF | Excel Discussion (Misc queries) |