date and range

Hello everybody! I'm trying to derive a formula where I count all of the values (duplicates and all) in a column (E), based on another column with dates (B). So I need to have a formula showing all values that fall in today, yesterday, 30 days and so on. I found the formula to get all unique...

I need help with the visual basic code to calculate interest based on a date. If the date is before 01/27/2015 I need the formula to be Amt*.12/365*days. If it is on or after 01/27/2015, I need it to be Amt*.10/365*days. <tbody> A B C D Date Amt Days Interest 01/25/2015 500.00 7 Amt...

I need a little help on a formula. I am trying to calculate leave time. So if your hire date is greater than 5yrs add 20hrs, if its greater then 10yrs add 60, and if greater than 20yrs add 98. Hopefully this makes sense. Any help would be great.

Hi, I have found some answers to somewhat similar questions but none that fits my need and unfortunately I am not experienced enough with VBA to piece together a functioning macro from what I've found searching online so far. What I need to do is to create a macro that runs automatically once...

<tbody> Row Index Column D (Start Date) Column E (End Date) A 20-JUL-2014 27-JUL-2014 B 01-OCT-2014 01-NOV-2014 C 07-OCT-2014 09-OCT-2014 D 09-OCT-2014 01-NOV-2014 E 14-AUG-2014 07-OCT-2014 </tbody> Seeking expert assistance in building a conditional format for...

Hi, I have tried to look around different forums in order to find some help with my problem, but I have not had any luck, so now I hope one of you might be able to help me out. I am working on generating an overview of my departments capacity in mandays pr. month for a Resource Management...

Hi Everyone, I need VBA help to replace content of a certain column based on multiple criterion. If the value in the Extension Column in Sheet1 is found in the Extension column in Sheet2 AND the Date in Sheet1 equals or falls between Date From and Date To in Sheet2, replace Number in Sheet1...

<TBODY> 10.2013</SPAN> 1</SPAN> 01.10.2013 </SPAN> 201310</SPAN> 001</SPAN> Oct 13</SPAN> 11.2013</SPAN> 2</SPAN> 01.11.2013</SPAN> 201311</SPAN> 002</SPAN> Nov 13</SPAN> 12.2013</SPAN> 3</SPAN> 01.12.2013</SPAN> 201312</SPAN> 003</SPAN> Dez 13</SPAN> 01.2014</SPAN>...

I have a date range that always covers a span of 3 different months. The net number of days and dates will vary. What formulas can I use to determine the month and year of the middle month? Example: Date range = 3/10/14-5/20/14 Required output = 042014 Thanks for the help!

Hello All--not sure if there is a way to do what I'm looking for and am open to all suggestions. Basically I am building a dashboard. One of my criteria will be Time Period of Shipments. For this example lets say my oldest shipment is 1/20/2014 and my most recent is 6/20/2014. Is there a...

Hello, I have pieced together a formula that will average a list of scores if 2 criteria are met. 1) is a id #, and the 2nd is a date range. The formula is as follows: =AVERAGEIFS(Sheet2!H:H,Sheet2!D:Sheet2!D,C10,Sheet2!G:G,">="&D5,Sheet2!G:G,"<="&D6) C10 = the agent id # sheet2!H:H is the...

Hi there, I have a set of data where the sales rep. creates a visit report. His name can appear in one of 6 fields. I want to count the number of visits and only once per sales rep. per visit. The name can appear on one of 6 columns and not always in the first. How can I count the first and...

<tbody> Date 1/1/14 7/1/14 14/1/14 21/1/14 28/1/14 Today Date 13/12/13 Sold 6 2 8 9 10 Bonus 2 1 3 3 3 Total ??????? Total 8 3 11 12 13 </tbody> Hi Guys and Girls, I am after a formula for the above sample table. In the total window with...

I have a table with a range of dates. Additionally I have a table with only a few of those dates and accompanying data entries. I need to be able fill in these entries into the corresponding dates in my first table leaving blank the cells next to the dates where there are no entries. Both vba...

I am trying to write a formula that will test if a re-fi date is in an annual date range (eg. 01/01/xx-12/31/xx). I need it to return the remaining balance at different dates or "0" depending on the outcomes. IF Re-Fi Date is > Annual period = Balance at the end of that year IF Re-Fi Date is...

I have a set of data which has dates in D4:AE4 starting from Jan 2011 to April 2013 underneath that i have data set of hours charged to a particular project. I am trying to see if there is a formula that i can use to determine the duration of the project based on what is populated in the rows...

Hello, I have a apparently simple issue which shows lots of resistance in spite of lots of research on array formulas and constant arrays. I have in a1 a date (let s say 12/05/13) and in b1 another date (15/05/13). In cell B3, I want an array composed of all the dates included in that range...

Hi, Please help I have 2 Columns of Holiday Dates (Column A is the "FROM" date; and Column B is the 'TO' date) and Column C is Peoples Names corresponding to the Holiday dates: ie: COLUMN 1 ; COLUMN 2 ; COLUMN 3 A1= 2 Jan 13 ; B1= 10 Jan 13 ; C1= Tom A2= 4 May 13 ; B2= 10 Jun 13 ...

Hi everyone, I am new to Excel programming and I have a question regarding finding the oldest 2 dates in a specific cell. I am trying to build an application that automatically sends an email but can't seem to filter the 2 oldest dates which is why when I click on send, all the records are...

I have a column with the following values: <tbody> SubmitDate November 8, 2012 1:37:07 PM GMT+05:30 November 8, 2012 9:32:03 AM GMT+05:30 November 8, 2012 4:32:54 AM GMT+05:30 November 7, 2012 10:28:11 PM GMT+05:30 November 7, 2012 8:36:43 PM GMT+05:30 November 7, 2012 6:33:13 AM...