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?
|