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?

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?

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

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