date and range

Hi all, am new to this forum so exuse me if I havent provided enough detail but this is all I have! I have an interviw after 7 years of being work on maternity leave ;-) :eeek:and my excel is not what it used to be but have been practising with the help of MR Excel!! :)The following is what i...

I need to create a comparison of MTD, YTD, and a 3 month Comparison in Excel 2007 using the current date (mm). I do not want to have to change a number to signify the month. The Data is laid out like this: <TABLE style="WIDTH: 480pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0...

Let me just say what a great resource this site is! Yesterday barry houdini was kind enough to offer up this formula: =IF(WORKDAY(A$1-1,ROWS(A$4:A4))>A$2,"",WORKDAY(A$1-1,ROWS(A$4:A4))) So now i put my start date in A1 and my end date in A2 and starting with A4 I get a list of the dates in...

Hi all, first posting here so please be gentle with me! I've done numerous searches to try to find a solution for my problem, but to no avail - certainly nothing that I can follow at work (some of the links to code snippets are blocked by work's firewall). My Excel 2007 spreadsheet has...

i'm trying to create a formula which calculates number of weeks into the quarter. for example, the quarter starts 1/26/2011 Q1 4/26/2011 Q2 7/26/2011 Q3 10/26/2011 Q4 and based on today's date, it would tell me how many weeks i'm into the Q...

So here's my issue. I have a Sheet (let's call this the Summary Sheet) with 3 pivot tables on it pulling information from 3 different sheets. One of the fields on all 3 of the pivot tables on the Summar Sheet is the Date field. I need to be able to write a macro that updates the date field...

Hello, I hope someone can help me with this issue. 1 sheet has all of my data. The other sheets have a custom template. I am trying to get Excel to populate a cell based on certain criteria. I have the formula.... =IF(AND( Data!B40>=DATE(2011,3,1), Data!B40<=DATE(2011,3,31)),Data!B40,"")...

Hi All, I have a spread sheetwith 7 Pivot Tables per sheet and about 10 sheets. It all works well but i would like to have a Macro that will allow me to input a date range then refresh all pivot tables to the same date range preferably by a nice user box that would pop up. I am new to...

Hi, I have a single spreadsheet with dates in Column A and measurements in Column B. I am trying to create a chart with a dynamic date range from 5 years ago to YTD. When a user enters a new date and data, I would like the chart to display the added data, calculate what 5 years prior to this is...

i have three dynamic columns that have dates in them. there are dates in column E, I, and J starting at row 5 and going down X number of rows...X because i have an external feed which updates and it results in column E, I and J going down different numbers of rows every time it updates....but...

So I am new to using macros and am looking for some help. I am hoping to do two things. 1) Create a macro that will quickly and automatically delete data that is outside of the date range I am interested in. (I think a date search, then a group delete would be quickest, but am unsure of how...

I use the sub below to check the date entered in a cell, then input a due code two cells to the left of the date cell. This occurs over the 12 months in year, three columns per month, starting in column F, row 5 and continuing to column AO. This code works perfectly when inputting a date...

Hey I've got a sheet in a workbook that I need to populate using named ranges from another (schedule sheet) w/in the same book. I have A1 as "week Number" and put the date in A2. my goal is to populate the range below it (b1:w13) with the appropriate week from the schedule. Each named ranges...

Here is the scenario: I have Column A that holds the date and Column B that shows many days have passed since that day in Column A passed. For example - if the date in Column A is 7/1/2010, Column B shows 8 because a total of 8 days passed from the value in Column A up to today's date...

Hello, I have a countif problem. In column I, I want to count the number of users for the date range in Cols G & F. Basically I am using a helper column (B) to count the first occurrence of a UID and counting that between dates. I just can't seem to get Col I to work right. It may be a bit hard...