Find Out How Many Ticks Were On Green Days, Amber Days And Red Days
Dec 19, 2008
I have a series of data that acts upon a traffic light system, i.e. Green, Amber and Red. These variables are posted along row 1 for example and there are 10 columns. Per column I have a tick and cross to answer a question. How can I find out how many ticks were on green days, amber days and red days? I have attached an example.
I'm basically looking for a forumla that will count each employees total scheduled work days for the month inserted and then depening upon the day it is will show how many days the employee has left to work for the month.
I have a spreadsheet in 2007. Days across the top for an entire year. So 365 columns. I need a macro to extract the 3 previous days , today's column, and the 3 next days and load to a different worksheet.
HTML worksheet A: 1/1/09, 1/2/09..... 10/17/09, 10/18/09, 10/19/09, 10/20/09, 10/21/09 .... 12/31/09 10 11 ... 14 15 17 12 22 ... 28 a g ... g c d d a ... a
the macro would create a worksheet B(if run on 10/19/09): 10/17/09, 10/18/09, 10/19/09, 10/20/09, 10/21/09 14 15 17 12 22 g c d d a
I want to calculate the end date of my German courses. This is how it works:
A course consists of 60 LU*. The course can occur i. e. three times a week: Monday, Wednesday and Friday. In each day the course lasts 2 LU, which means 6 LU each week. There is no course on Tuesday, Thursday, Saturday, Sunday and on holidays. Therefore this type of course that begins on 18-Nov-2013 will end on 03-Feb-2014.
Another course which occurs Tuesday, Thursday and Saturday, and respectively has 2 LU on Tuesday, 2 LU on Thursday and 3 LU on Saturday and starts on 03-Dec-2013 will end on 06-Feb-2014.
Therefore I want to create a worksheet where I set the start date, choose the days and respectively the LU amount on those days. The end date shall be calculated according to these criteria.
The workday function on excel cannot do this and I do not have any programming skills to work with VBA.
I wanted to determine the number of days between two dates. Specifically, if the initial date is in one month, and the second is in a different month and an output would result a number of days in each month until the final date. BUT I have a large amount of data to do this for in a list view, way to put a formula in excel and just drag down the entire list to get the required information. see below for an example.
The result I'm looking for is the separate the months and only show the relevant months between the two dates in one cell or the adjacent. Something similar to the table outlined below.
How to find five consecutive working days for the staffs who worked only in night shift basis and if this comes true then to find other night shift for particular staff based on Bank ID and putting those data's in new excel sheet believe this can done through a macro.
Its new assignment to me to find the staffs to make the inconvenience allowance for the staffs who worked in night shift for five consecutive days and if they worked for five consecutive days then they eligible for other night shift days they have worked.
Given the data how it looks in our attendance. In the below data night shift criteria true stands for staffs who worked in night shift and false stands for staffs who worked in day shift.
Can Anybody help me with a function that will arange all days from January acorrdingly with the year 2010. I am attacing a sample file to make it clear. I need the function to Check which month is in Cell H1 and arrange the days accordingly to the month and the year.
In my example the code must change the Cell values Like this: ...
I have a spreadsheet that contains dates in format mm/dd/yyyy. Lets call this Column C(Paydate). In Column A I have a date that needs to be a 2 business days before the paydate. If this date in column A winds up being a Saturday or Sunday, the function needs to return the previous Friday. If the date is any weekday then it should return that weekday
For example: C1 = 10/18/2013(a Friday) then A1=10/16/2013 C2 = 10/14/2013(a Monday) then A2= 10/11/2013(the previous Friday since 2 days before 10/14/2013 is a Saturday) C3 = 10/15/2013(a Tuesday) then A3= 10/11/2013(the previous Friday since 2 days before 10/15/2013 is a Sunday)
I am assessing the impact of product price increases on volume (qty) and sales (£/$).
The prices are changed sporadically and at no set intervals. For example pries were changed on the 15th Jan and 13th Feb this year.
We have set reporting dates (calender months) so i am hoping to be able to divide the report which shows sales & qty's during the 15th Jan - 13th Feb segment and apportion them to the correct months.
I have the start & end dates of the calender months in cells A4:B18 and each time a new report is run (ie 15th Jan or 13th Feb, these dates go across the top i.e. cell C3 = 15th jan & D3 = 13th Feb.
I would like to return a % in cell C4 which relates to the amount of total days in the segment that relate to Jan (ie. 29 days in the segment, 16 relate to Jan so 55.2%).
Cell C5 would then return a % which relates to the amount of total days in the segment that relate to Feb (29 days in the segment, 13 relate to Feb so 44.8%).
Cells D4&D5 would return the next reporting segment and how many days in Jan/Feb respectively (the answer will be 0 but a constant formula acrosss all would be perfect. tried to give as much info as poss.
I want to pick a range of dates and find the number of days without sales between those dates. So, a formula that will look to a start date in A1 and an end date in B2, and then count the number of days that did not have sales between. Index/Match/Countif/Dateif I can't seem to make anything work.
the spreadsheet i've set up have two days in it, and i need to work out the number of days between the dates.
(Column H) Date Work was requested (Column S) Date Work was completed
Now i thought i could use
=DAYS360(H13,S13,TRUE) This does return the number of days between the dates, but if theres no completed date yet (alot of jobs take weeks somethings months to complete) it returns a value of -38541 for example.
In A column the date something is received will be entered.
In B column there is a drop down list that has "insured" "Fee" "Aged Debt" "Other".
In C column I am trying to get another date to populate dependant on what is picked from column B, so if Insured is picked then 1 working day needs to be added to the date in column A and populate in column C. If any of the other 3 options are selected 5 working days needs to be added to the date in column A and populated in column C.
I have been using this formula: =IF(B2="","",IF(B2="Insured",A2+1,A2+5)) however this is not working days and I am stuck how to get to add working days
I have a column with people(A) and their date of birth(C). I'm looking to find out the number of days when their next birthday is. I searched through here and couldn't find anything. Is there a formula I can use that would calculate this, year after year after year??
I am trying to find a formula that looks up by SS#and a date that is within two days of each other. Example file is attached but I have put the two table below just in case. The file explains it better.
I have a few thousand rows of this. The X's could be placed in any column. I need to go through this data and determine the maximum days between X's for each row. I can't think of how to do something like this with either an equation or with VBA.
I can't get it to line up in the table above. But basically, there could be an X in Sunday and on Wednesday in one row. The next, could be every day of the week, the next could be any other combination. There could be 7 X's, 1 X, 3 X's, whatever.
I have a spreadsheet that keeps track of incoming and outgoing orders. I am wondering if there is a formula that I could use to calculate how many days each order is in house. Say, if it comes in on 3/10 and goes out on 3/13. It would have to disclude the weekends. So if an order came in on friday it wouldn't count saturday and sunday in its totaling. I would also like to figure the average time an order spends in house form this formula.