Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using WORKDAY function | Excel Discussion (Misc queries) | |||
WORKDAY function | Excel Worksheet Functions | |||
Using WORKDAY function | Excel Worksheet Functions | |||
Workday function | Excel Worksheet Functions | |||
How do I get the WORKDAY function? | Excel Discussion (Misc queries) |