Column C has the actual Date
Column H the beginning of the month
Column I the end of the month and
Column D the dollar amount
Now I would like to count the number of contracts that fall in the following categories in a given month. The minimum number is in Column N and the maximum in Column O.
1-499,999
500,000-2,499,999
2,500,000-4,999,999
5,000,000-12,499,999
12,500,000-24,999,999
25,000,000-64,999,999
65,000,000+
I can get the count for each category but am having difficulty with the count in the specific month. Does any one have any suggestions - other than a pivot table?
Now I need to find no. of days which fall under the month of FEB from the date range 21-Feb-2013 till 07-Mar-2013 (Col C2, Col D2) which are working days. so that I can subtract that from no. of working days for that month (FEB) to get the no. of working days which the person has actually worked.
I have three companies in column A, In Column B I have a date of when an item was sent to them, in Column C I have the amount of days this item has been out with that company. Is there a formula that will count the number of days an item has been out with one of the companies per month, and find an average if more than 1 item has been sent per month. Two items have been sent to company A in Sep 09, one item has been there 10 days the other 20 days, the answer I would be looking for is 15.
I have a large spreadsheet which holds lots of data with date ranges that i need to performs different actions to. Any way to identify the number of days, per calender month, that falls in a date range.
sample data...
Start Date End Date Old Value New Value
08/03/2010 18/06/2010 16758.2 16758.1
[Code] .......
I need to break down the total number of days per month
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
24 30 31 18
[Code] ......
As you can see this also laps into a new year, which poses my next problem, ill probably just add more columns on to the end of the table for that though...
I will later apply different calculations to these cells but in short need to get a calculation for the number of days per month first.
(in short spreading the new value out accross the year then multiplying it by the days... i also need to apply a further daily volume cal to it).
I would like to create a monthly inventory, based on workdays (Monday - Friday)Myrna Larson has a formula that I would like to use with the workday function, but I don't know how to combine them.
There are dates in column C and I need to count how many days are coming due within 90 days of each date based on the today() function but do not exceed the 90 days.
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.
I need a formula to count how many days hours & mins between 2 dates but included in the formula need to ensure it only counts business days.
Column A 02/09/2011 13:00
Column AO 02/09/2011 13:02
I need in Column AP to show 0 00:02
The formula I have tried using is - =IF(AO3="","",AO3-A3) which doesnt work as instead of showing 0 00:02 it shows 1 00:02. I dont want it to count as 1 day just 2 mins.
Once that has been worked out I need to include WORKDAYS formula to only count working days. I have created the list on 'Controls' Tab Column A10:A47.
Need a way to get/calculate ALL of the days of the months from a date range entered into an inputbox in which a user may enter any day of a month? In other words, the user enters 9/14/2009 in the first inputbox then 10/8/2012 in the second and code would calculate the number of days as 9/1/2009 - 10/31/2012.
Here is the current code I'm using that calculates only the exact days:
I have is a start rent date and an end rent date. They want to break down how many days in each month the item was on rent so they have a column for each month. For example say an item was rented on 12/14/08 and returned on 1/12/09. It was rented for a total of 30days 18 days in December and 12 days in January. So I would need a function in each column that would return a 14 in the December Column and a 12 in the January Column. there are over 350 rows and they are doing the process manually right now and taking several days.
Also I just noticed that the date range is currently entered as a text in the format 2008-12-14 so YYYY-MM-DD. Don't know if the text will be a problem.
Just attached an expample. In it I am trying to find a function to fill in the green cells.
I have 5 columns: Employee Name, Start Date, Probation Time, Probation Ends, Benefits Start.
I want the Benefits Start column to populate the name of the month that follows the Probation Ends date.
For example Employee A starts on March 16. Probation time is 90 days. Probation Ends is 6/14/09. The Benefits start date is 7/1/09, however I want this column to just say July.
Im trying to use the equivilent of: =DAY(DATE(YEAR(H5),MONTH(H5)+1,0)) in vba. but i am having trouble with the use proper parenthesis.
basically the above will work in an excel workbook and return the number of days in a month. thats all i really need. so if there is an easier way, which im sure there is, then im up for it...
I am looking for a formula that will tell me how many days in each month for which a given time span is active. For example the time span 1/1/2014-2/28/14. I want to know the time span is active for 31 days in January and 28 days in February. Another example: time span of 1/15/2014-2/28/2014. I want to know that the time span would be active for 16 days in January and 28 days in February. I am looking for a formula that will capture the amount of days in each month for which the time span covers. as I only know how to write a formula with multiple if statements that require a different formula for each given month, rather than one formula that applies to all months.
In my current salary sheet "Days fill auto according to given months" from 1-31 as you can see in my attached salary sheet
Salary.xls
the Big problem is i want my salary sheet give dates from 23-22 for example if i select "January" sheet should display date from "Jan-Feb" starting from 23rd Jan to 22 Feb only.... and if I select February than sheet should display date from 23rd Feb to 22 March.... and so on
and if there any blank cell left in the dates area it will highlight it with RED auto as u can see in attached sheet.
I receive an extract from our Financial System monthly which list all the balances for each date of the month (both workings day and week-end(Sat. and Sun.)).
I would like to create a macro which will extract only working date (Mon.- Fri) and the balances in the columns.
I currently am trying to refine some spreadsheets at work (hospital setting). The type of files im working with are medication sheets where on the left it states the medication and to the right of it, the cells have the days of the month(1-31) but I need them to change depending on the day they come into our facility. Above the numbers i would also like it to say the day of week with the first initial (M, T, W, T, F, S, S) in the cells are the top. It is something that we have to make for each day it it gets really annoying and is a waste of time moving the dates over for every day. find a way where I can open the file and the numbers and letters are all in the right place without having to change it for the day that the patients are coming in.
I have checked searching the forums for this but nothing that really matches what I am looking for. I am trying to, from a date, deduce how many days there are in that month. I have tried a solution where I look at EOMONTH adding and subtracting but this is quite cumbersome. Is there some code out there where someone has solved this?
