Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 51
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5,651
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 51
Default weekday() help please?

Ron Thanks a lot , it works great!!

thank you
  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5,651
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
WEEKDAY() function: display TEXT not numeric weekday tom Excel Discussion (Misc queries) 3 November 21st 06 05:32 PM
WEEKDAY() Epinn New Users to Excel 29 September 10th 06 11:39 AM
Weekday LB79 Excel Worksheet Functions 2 July 28th 06 02:59 PM
Weekday Darts via OfficeKB.com Excel Discussion (Misc queries) 3 May 26th 06 06:26 PM
WEEKDAY using IF lunker55 Excel Discussion (Misc queries) 2 December 4th 04 04:34 PM


All times are GMT +1. The time now is 10:59 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"