# workday

1. ### Add (+1) Workday to formula

Dear all, Please see my formula below: =IF(D16="",SUMIF(\$A\$7:\$A\$36,E16,\$G\$7:\$G\$36)+1,IF(D16<>"",WORKDAY(G15,D16),WORKDAY(G15,D16))) This formula is a little hard to explain with going into masses of details. If you look at the +1 within the formula, this adds 1day to a date... how do I add a...
2. ### today() vs workday()

Hi When I use today(), it will return today date in this format 10\10\2017 so far so good. However, when I use workday(), it will return number like 43032. I know I have to change the format to date but why I did not need to do that with today(). Thanks
3. ### workday() and networkdays() are got given the same result

Hi I tried to use workday() and networkdays() to see the difference. I am surprised that I got different result. I live in Canada and today is holiday. I did not enter any holiday in the workday() function <tbody> task start date # of days =WORKDAY(B2,C2) =NETWORKDAYS(B2,D2) <tbody>...
4. ### Add workday from the value of the cell above.

Hello everybody, How can i make a formula that adds a workday of the date givin by the cell above? something like this? i want to type the formula in a sheet (no vba.) =Workday(Activecell.offset(-1,0),1) ? i can't seem to figure it out. ty.
5. ### Determing the last workday of the month

Hello, I'm hoping someone can assist me, I need to have a formula that calculates when the last workday of the month is, holidays would not be counted as work days. I then need for "EOM" to appear in the column representing the last working day of the month. Currently I have this formula that...
6. ### Formula for calculating number of days between start and end date excluding weekends and holidays

Hi there, I am trying to create a formula that calculates 'days of work' within weekdays except for weekends and holidays. I acknowledge that there is 'Workday' function but it requires days of work. For example, if you have Start date: 2017-03-29 and End date: 2017-04-04 with a holiday at...
7. ### Excel 2010 Workday and Weekday Formula

Hi, I have a Worksheet that contains a list of colleagues and their annual leave. The dates are horizontal and they are all formulas referring to a date in cell B1. The formulas are in the format of =workday(C4,1). Some of these formulas are formatted as ddd to show the day of the week. What I...
8. ### WORKDAY formula round up (perhaps arrays)

Hello! I have a problem I am trying to solve. Problem 1. 1. I have daily dates from 01.01.2017 - 31.12.2017 -> cells B1:NB1 2. I have a cost of 100€ that I have to pay every month, on the 15th, nearest to the WORKDAY. Anyone knows what formula to use in order to insert it in B2 (just below...
9. ### Date 10th of Each Month

I have a spreadsheet that calculates the future due date of projects. The project is due on the 10th of each month but has to account for weekends and holidays. If a holiday (handled by the vlookup) or weekend is present is shows the previous workday. The below formula works well, however, it...
10. ### Calculating Holidays

I am needing to calculate holidays that I can use as part of the workday function. I used the following formula for Thanksgiving but need help understanding what it is doing so I can calculate these other holidays. =DATE(C2,11,1)+21+CHOOSE(WEEKDAY(DATE(C2,11,1)),4,3,2,1,0,6,5) --C2 is the...
11. ### First Business Day of Next Month excel formula

Hello, I need a formula that gives me the first business day of the next month according to a date in cell A1. For example, if: A1 = 7/29/16 I would like A2 to read = 8/1/16 Please and thank you!
12. ### Excel (2007) "workday" how to add days to a date and include saturday, for a schedule.

Hello All, I am new to Excel, and working on a project timeline. I am trying to insert a number of days in column "b" for the amount of time each job will take. In column "c" I have the start date, and in column "d" i have the end date. I would like it to work so that when I enter the days...
13. ### Last friday of month excluding holidays

Hi, I have a formula that gives me the last Friday of the month, but would like to ensure that holidays are considered in the formula. I have a list of holidays in a table named 'Holidays'. I have tried to add this in to the formula, but have had no luck...
14. ### Exclude Weekends

Hi Excel guru's. I have have to track orders that must be completed within a certain date range, e.g. within 90 days of create date. A simple formula of can address what the expiration date would be, however often these expiration dates land on a weekend. Simply using a =WORKDAY() is...
15. ### EOMONTH/WORKDAY question

Hi guys, In cell A1 I need to get todays date i.e =today() or 5 Sept 2015 - that's what I can do.. In cell A2 I need to see the last working day of the previous month i.e. 31 Aug, in cell A3 I need the previous last working day i.e. 31 July. Ive used EOMONTH but I struggle with the cell A2...
16. ### Excel "Workday" function seems to gneerate wrong weekends

This could very easily be operator error but---this list of dates below (generated with the Workday function) indicates that August 13 is a Friday (instead of a Thursday) then skips the next days as if they were the weekend. The August 12 date was entered with [=DATE(15,8,12)] and the subsequent...
17. ### Transforming weekend date to previous Friday

Is there a code or formula that would convert a weekend date to the previous friday at 11:59pm? For example: in cell A1 I have "5/23/15 8:37", which is a saturday. How could I have that number transformed into "5/22/15 23:59", which is the friday prior to that saturday? I have several other...
18. ### Workday not behaving as it should (Excel 2007)

I'm trying to show deadline dates which are the 3rd working day of the month. I'm using =Workday(start date, number of offset days, Holidays). The Holidays element is not causing the issue (I get the same issue if I have Holidays or not) so it's not that. The examples I'll show, therefore, do...
19. ### Workday Function

I need the following formulas to report only weekdays. =IF(F2="","",IF(K2<"","Submitted",IF(F2>=TODAY(),EDATE(F2,0)-30,IF(F2<TODAY(),"Today","")))) =IF(F2="","",IF(G2="S",EDATE(F2,-2),IF(G2="R",EDATE(F2,-2),IF(G2="A","Not Needed",IF(H2="A","Bed Date...
20. ### Allocating competent staff to specific roles

I need your help, MrExcel. I am using Excel2010. The workspace consists of specific roles that needs to be filled at all times by competent staff. There are more workers than roles, and the workers may be competent in more than 1 role each. For the sake of this example I'll cut the number of...

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
• Complex Heat Map using conditional formatting
Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
• Conditional formatting
Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...