Hi,
I need to calculate the number of days in each year between two dates.
Start Date: 25-12-2010 and End Date: 03-01-2011
The result should be: 7 days in 2010 and 3 days in 2011.
Regards,
Elio Fernandes
hi ,
we are prepairing an annual report for the Activation & Deactivation of Some Data Cards ,
our system provide us the number of days from which any card is activated or deactivated i have to convert it to Year ,month, & days if any one please help It should by like
396 = 01 year , 01 month ,01 Day
i am dividing it by 30 (assuming 30 days as a month .)
Please help if any one can
Hi!
Sheet 1 Column A2 to A367 contains dates from Jan 1 through Dec 31.
Column AB2 to AB367 contains values for each of these dates for 2008.
Column AC2 to AC367 contains values for 2009.
Column AD2 to AD367 contains values for 2010 etc etc.
What I'd be really grateful for is either a formula or code that produces a value in Sheet 2 Cell D6 for the sum of cells for the previous year to date and automatically advances by 1 column each year i.e. for 2009 it will look at column AB and for 2010 it will look at column AC.
Many thanks!
Hi,
I am tearing my hair out with what should be a fairly simple problem!
Here is a simplified example of what I am tring to do:
In column A I have a start date, i.e. 01/01/03
In column B I have a start date, i.e. 01/06/04
The difference between them being a period of 517 days - In Column C I am trying to allocate the number of days that are in the 2003 calendar year, in Column D I am trying to allocate the number of days that are in the 2004 calendar year and in in Column E I am trying to allocate the number of days that are in the 2005 calendar year.
Is there a simple formula that I can use that will do this? I have over 3000 rows of data to calculate and am sure there is an esy way to do this!
Sunny
Can anyone tell me how to find out the number of days in a calendar year using excel?
Hi All
I am trying to identify a formula that will allow me to identify how many rental days occured between two dates in a particular month for a report I have to produce each month.
The report shows cars out on rent which in some case have been out for over 12 months and I need to be able to calculate how many rental days have occured for each booking in the relevant reporting month. I am currently doing this manually by manipulating data but want to try and find an automated way so I can write a macro!
I have attached an example of the type of data I am presented with:
Thanks in advance
Hi
I'm trying to put together a sickness calculator that works on a rolling year basis.
I need to count the number of days between two dates, but only count the working days, which are Tuesday, Wednesday, Friday and Saturday (so exclude Mondays, Thursdays, Sundays and bank holidays) and only those dates which fall within the last year. To explain:
Let's say that today's date is 4 June 2010.
Column A holds 'Date from'.
Column B holds 'Date to'.
Column C needs to count the number of working days between the two dates (correctly excluding non-working days and bank holidays.)
Column D should count the number of working days between the Col A and Col B dates, as long as the dates are within the past year.
It's columns C and D that I need assistance with please.
Examples:-
A5 contains Mon 4 May 09
B5 contains Wed 6 May 09
C5 should calculate as 2 - because there are two working days between those dates (the Tues and the Wed).
D5 should calculate as 0 - because this range of dates is over a year ago.
A6 contains Fri 19 June 09
B6 contains Tues 23 June 09
C6 should calculate as 3 - (the Fri, Sat and Tues).
D6 should calculate as 3 - because this range of dates is within the past year.
A7 contains Tue 2 June 09
B7 contains Sat 6 June 09
C7 calculates as 4 - (the Tues, Wed, Fri and Sat).
D7 should calculate as 2 - because the 5th & 6th June 09 are working days within the past year but the 2nd & 3rd June 09 are not.
Help!!
Thanks in advance.
p.s. I already have a range called 'Holidays' which lists all bank holidays.
All,
I'm trying to figure out a way to compare shipping days year over year. In other words, at a specific calendar date, each year may have a different count of shipping days. However, if I have 18 shipping days so far in a month, I want to compare the sales for the same amount of shipping days in the same month of the previous year.
Basically, I have tables set up for each year that have rows for each calendar day. Holidays and weekend days are marked with a 1 in column A, and business days are marked with a 2. I can't figure out a way to count forward in a month the amount of 2's and stop after getting to a specific number of them (i.e. if I want it to count 18 "2's", how to get it to stop at the 18th one).
Any thoughts?
Thanks.
What am I doing wrong trying to create function when input is "2011" out put is 1st day of that year "01/01/2011" in date format.
I have looked for almost 2 hours over the internet for this solution but could not find one. Hopefully there's someone here with a solution.
Summary:
I have a date to which i am adding a number (of days) to arrive at a future date. I want all days to be counted including saturdays, sundays, holidays but I want only the dates that I have in another column to be excluded (because our holidays/days offs are spread out over the week and are very inconsistent BUT I do have the list of dates that should be skipped).
Here's how I have it setup
Sheet1 - A1 = 5 May 2011 (Date)
Sheet1 - B1 = 10 (Number of days to add to above date to arrive at future date)
Sheet1 - C1 = Formula needed here that adds A1+B1 (with all days that are in a column A in Sheet2 skipped till the total days equals 10). Another way to explain would be that the total days or actual workdays has to be 10 days skipping the days in the list. So in this example the answer needs to be 19th may.
Sheet2 - beginning from A1 going down 1 day per row (thats all is in this column) This column is formatted date format and I will be adding new dates as they become available!
7 may
9 may
10 may
12 may
Thanks!
Flyboy
