dates and sum

Hello, I have a few challenges that I need your help with. I have a daily sales log which i have to convert to provide data in three different formats: 1) weekly - sum 7 consecutive days from a starting date; 2) weekly - starting 1st of each month and up to including Sunday of that week. The...

Hi, I am new to the site but hoping someone can help with ease... I have a tab in a workbook that includes a list of dates when a companys vacancies were given approval - column E. I have another column that provides for the date when the vacancy was filled - column O. I am looking to create...

Column A has a full year of dates. Column L has the number I need. I need to find the last populated date for each month and pull the value from column L. (Some may end on the 20th or some the 31st....etc) I was using =lookup but it doesn't seem to be getting there for me.

My "Days Worked" column keeps breaking with every new month... and i think i have it coded wrong. My formula is =NETWORKDAYS($C$7,$C$8)*-1-$C$11 C7 is Today / C8 is Start Date (beginning of the month) / C11 is Holidays (which i manually enter due to company picks).. Currently it's showing...

Hi, I'm trying to create a simple table that counts dates that fall into a specific age range: <tbody> 0-10 days old ? 10-20 days old ? Over 20 days old ? </tbody> The easiest way would be to add a column to where the dates are and insert the networkdays formula but I need to avoid and...

Hello, I have an issue in getting excel to sum a range beginning at Jan-17 up to and including the current month that will auto update ongoing e.g. next month it will include Jan17-Mar17. I can only seem to have it sum just Jan-17 is it best to use sumifs or sumproduct? Will the formatting of...

Strange issue I'm hoping someone can help me out on: I have a tall data set that has an amount tied to a person and a date, say like such (as a simplified version - the actual data has several thousands of lines for individual people stretching back 90 days): <style type="text/css">...

Hi All, I hoping someone may be able to help. I'm creating a purchase ledger and would like to include at the top all a total of: Total Unpaid Payments that are now overdue Payments that fall within 30 days Payments that fall within 14 days Payments that fall within 7 days Below I have tried...

Hello, From the below I have in cell A1:A31 dates. B1:B31 DOW and C1:C31 number of rooms sold. I am wanting a formula that firstly breaks the month down into weeks that run Fri-Thurs and then calculates the number of rooms sold during that week. This will be done every month and so the DOW...

So I have a range of bets that I would like to summarize by having a cell display the most amount of money won and another showing money loss on a single day and for it to constantly calculate the biggest amount. What would be the best approach for this? The data is formatted like below...

I have different dates in column A, names in column B and a product I column C. Is there a formula that will add 7 days to the most recent date for a given name that next time that name is entered if a certain product was entered? Column A Column B Column C 1/1/2015 John...

Hello, I have some data that I want to add up cumulatively but it has a condition on its date of operation in other columns for instance; <colgroup><col span="4"></colgroup><tbody> A B C D 1 1234 1990 2 673 1990 1997 3 2134 1991 4 7878 1992 1996 5 0 1992 6 567 1994 1999 7...

I've got a few Excel sheets with data that looks like this: Apr-2012 1 Apr-2012 1 2 Apr-2012 .34 3 4 Jun-2012 .8 5 Nov-2012 .2 Jan-2013 1 etc. What this data means is this: The first date (the...

Hi again Since my last question yielded great help, I'll try again with another one: I have a table containing employee numbers and their respective number of contractual working hours. Furthermore, the table contains a start date and end date showing when the given number of contractual...

Today is 14-Nov-12 Hello Forum, appreciate some help with this headache ;-) The office has a large spreadsheet where Column A has a "start date" and Column B "Clearance Date" We would like to see a red font for those dates that have passed the current date. A yellow cell for dates that are...

<tbody> A B C Here is what i need 1 Date # of hours Start Date____i want to enter any day 2 1/1/12 0 # of hours_____enter any number of hours 3 1/2/12 6 End Date______need a return date 4 1/3/12 6 so if i enter 1/2/12 as enter date 5 1/4/12 6 and 24 hours 6 1/5/12 0 i need the end...

I have tried the multiple solutions on this forum and can not get it to work. Use-Case: I want to sum a total amount of cells on the IF statement that they are considered a "Renewal" and that they are within the dates of 2/1-2/28/2012. So 2 if clauses, or 3 if I have to specify the 2/1/2012...

I am trying to find out the exact sum of time down to the hh:mm:ss on my pivot table from different people on different dates (in half hour increments). Hence: Columns: name name name name name Rows: 01-01-2010 12:00 01-01-2010 12:30 I need a sum of time from each column WITHOUT the dates...

Hi all, I got a problem, some financial data I have to sum. There are two sets of data; Forecasts and Actuals; i.e. Row: A1: FY2011 (Forecast) B1: FY2011 (Actual) ...... this goes on for a couple of years. Row A20: Net profitFY2011(Forecast), B20: Net profitFY2011(Actual) ... this goes...