workday

Let me just say what a great resource this site is! Yesterday barry houdini was kind enough to offer up this formula: =IF(WORKDAY(A$1-1,ROWS(A$4:A4))>A$2,"",WORKDAY(A$1-1,ROWS(A$4:A4))) So now i put my start date in A1 and my end date in A2 and starting with A4 I get a list of the dates in...

Hi, This cel (dutch; workday function)= =WERKDAG(D2;C2-1) Changes into the following when I save and re-open: (dutch translation: Blad = sheet) =Blad3!_FilterDatabase(D2;C2-1) After that, the formulas don't work when I start auto-filtering. (I work with mac for excel 2011)

Hi. I would like an excel formula in say B1 to minus a month from the date A1, but only return a workday. If the date returned is not a workday, I would like it to return the next working day (positive only). Thank you for your help.

I am attempting to calculate the start date when the desired end date is known (Column D), and the duration to complete the work is also known (50 days, Column C). I'm using Excel 2003, and this info will be broadcast to multiple users, so using the Analysis Tool Pack is not an option. Is...

Hi All, I'm trying to build a tool to lookup delivery times in Excel 2007 and I'm a bit stuck. The requirements i have are; - Each suburb can have a different delivery timeframe, these are located on a separate sheet - Delivery times are in working days so it needs to account for weekends and...

This is the formula I use to check the price of, say, YHOO, at close , from 6 days ago. = INDEX( GoogleFinance( "YHOO" ; "Close" ; TODAY()-6 ) ; 2 ; 2 ) The problem is that it registers dat 360 days a year and I don't know how to configure it to register data from workdays only. Thanks! A...

I have tried for a while on this, searched like crazy but have not had much luck, any help is appreciated. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I have found another thread that has been quite helpful but does not quite address my...

Hello, I have the challenge of calcuting response times within 1 working day for cases filed by my clients. My current function does not account for workdays and holidays. So if a case is filed on a Friday evening and I respond on Monday morning, I have missed my allowed response time window...

Hello, I have searched for hours and hours for a solution to no avail, so I'm hoping the experts here can help me figure this out! I'm trying to calculate a start date, given an end date, lead time and holiday list, but including Saturdays as a workday. For example, A1 = End Date, such as...

Hi guys, Well this is my problem. I work scheduling trucks and I have the following problem. I need to calculate arrival times for merchandise. So if the truck arrives lets say NOV 21st in three different cells would calculate NOV20, nov19 and nov 18. The problem now is that I can not count...

Hi there, I’ve had a good look around for an answer to this but no luck! Hope somebody can help. I’m familiar with using the workday function to work out what the date is it in 6 working days time, however what I can't work out is how I can evaluate whether a date is a working day on not? My...

I have searched for a Function excluding Fridays and found one by barry houdini for excluding Sundays : If I have a date in A1 and want to add the number of workdays in B1, counting all days except Fridays as workdays: =A1-WEEKDAY(A1,3)+INT(7/6*(B1+MIN(5,WEEKDAY(A1,3)))) format as date...How...