Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 51
Default workday() function, how does it work?

Hi all,
i have in a worksheet dates in column A1.
i would like to know for these dates if this particular day is the
fifth working day of the month in which it is. i searched the group
and i found that workday() will do the job, i downloaded the pack that
will make it work but i am finding hard time implementing it. would
you please help on this task?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1,805
Default workday() function, how does it work?

Use
=WORKDAY(DATE(YEAR(A1),MONTH(A1),1),4,Holidays)

Where the range named Holidays contains the holiday list
If you don't care about holidays then use
=WORKDAY(DATE(YEAR(A1),MONTH(A1),1),4)
and copy down...

Workday returns the working after N number of days from the date
=WORKDAY(date,N) if holidays are not used...

"Totti" wrote:

Hi all,
i have in a worksheet dates in column A1.
i would like to know for these dates if this particular day is the
fifth working day of the month in which it is. i searched the group
and i found that workday() will do the job, i downloaded the pack that
will make it work but i am finding hard time implementing it. would
you please help on this task?

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 5,651
Default workday() function, how does it work?

On Mon, 27 Oct 2008 11:15:01 -0700, Sheeloo <="to" & CHAR(95) & "sheeloo" &
CHAR(64) & "hotmail.com" wrote:


"Totti" wrote:

Hi all,
i have in a worksheet dates in column A1.
i would like to know for these dates if this particular day is the
fifth working day of the month in which it is. i searched the group
and i found that workday() will do the job, i downloaded the pack that
will make it work but i am finding hard time implementing it. would
you please help on this task?



Use
=WORKDAY(DATE(YEAR(A1),MONTH(A1),1),4,Holidays)


Your formula does not give consistent results.

In particular, if the first of the month is on a Saturday or Sunday, it will
return the 4th and not the 5th working day.

check 1 march 2008
or 1 feb 2009

Better to use what I previously posted:

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

--ron
  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1,805
Default workday() function, how does it work?

Thanks for pointing this out...
I should have thought of this.

"Ron Rosenfeld" wrote:

On Mon, 27 Oct 2008 11:15:01 -0700, Sheeloo <="to" & CHAR(95) & "sheeloo" &
CHAR(64) & "hotmail.com" wrote:


"Totti" wrote:

Hi all,
i have in a worksheet dates in column A1.
i would like to know for these dates if this particular day is the
fifth working day of the month in which it is. i searched the group
and i found that workday() will do the job, i downloaded the pack that
will make it work but i am finding hard time implementing it. would
you please help on this task?



Use
=WORKDAY(DATE(YEAR(A1),MONTH(A1),1),4,Holidays)


Your formula does not give consistent results.

In particular, if the first of the month is on a Saturday or Sunday, it will
return the 4th and not the 5th working day.

check 1 march 2008
or 1 feb 2009

Better to use what I previously posted:

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

--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
Using WORKDAY function Frik Excel Discussion (Misc queries) 4 June 19th 07 12:27 PM
WORKDAY function jpac Excel Worksheet Functions 1 December 22nd 06 10:50 PM
Using WORKDAY function MT Excel Worksheet Functions 2 June 5th 06 07:53 PM
Workday function 4110 Excel Worksheet Functions 0 January 19th 06 04:02 PM
How do I get the WORKDAY function? jorfo Excel Discussion (Misc queries) 1 December 5th 04 12:01 AM


All times are GMT +1. The time now is 10:16 AM.

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"