Calculating Due Date
I have an Effective_Date field in my table and need to calculate due dates.
If the date is before or equal to the 15th of the month, show the Effective
Date, if after show the first of the next month, that would be the 1st due
date. Then I need to show the second date as 30 days from the first date and
the third date as 60 days from then. The other problem I'm have is in a
report I want to show all of those with a date in say "October" whether it is
the 1st, 2nd or 3rd due date. Can this be done with an expression, or do I
need to create fields for those dates? Thanks...Need formula to check data in 2 columns to sum 3rd column
Need a formula to enter on Report Sheet under Month as indicated from tables below. The data base worksheet has info inserted daily and the report will be on another worksheet to calculate as data is updated. Any ideas??
(Need total paid for all rows paid to Name 1 with dates in month of Jan)
Data Base Worksheet Report Sheet
NAME DATE PAID NAME JAN FEB
Name 1 01/01/04 $200.00 Name 1 ??Paid ??Paid
Name 1 01/22/04 $200.00 Name 2 ??Paid ??Paid
Name 2 01/15/04 $200.00
Name 1 02/04/04 $200.00
try the following
1"),--(YEAR(B1:B100)=2004),--(MONTH(B1:...Same proc... same data source... different results
A developer in our office has come to me asking for assistance, and I
have no idea what can be causing this.
We're running SQL Server 2005 SP3. We have a (when printer) 23 page
long stored proc which gathers and formats data for a report. The proc
makes use of Temp tables, table variables, FOR XML PATH, Rank(),
She runs the proc... and stores the result set to a .txt file.
She then runs it again, stores the data to a 2nd txt file.
She then uses WinMerge to look at the differences between the two
files, and they differ. Out of the 80,000 rows or some...dowloading data of CSV file to excel file
I have the CSV file with more that 200000 lines and I need to import it into
the excel sheet. I have tried using Import wizard and it did not work. I am
using the Excel 2003.
Please let me know the other way I can import the complete data to the excel.
xl2003 only has 64k rows in a worksheet.
Maybe you could use your favorite text editor and split your file into 3 smaller
pieces. And then import each piece into its own sheet????
Igneshwara reddy wrote:
> I have the CSV file with more that 200000 lines and I need ...Error creating dates
I can't create new dates in Microsoft Outlook Calendary
When i do double click nothing happens...
Thanks in advance.
Reboot your computer.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, Virgulilla asked:
| I can't create new dates in Microsoft Outlook Calendary
| When i do double click nothing happens...
| Any idea?
| Thanks in advance.
...Graphs/Charts by country. Same Graph, different Source Data
I have sales information for 5 countries, each on separate sheets ( the
sheets are identical in format) . I have made graphs for the first country,
and I want to copy them to the other countries, and change the references to
pick up the right country information. Is there a quick way of doing this or
do i have to go into source information for each series for each graph and
change the sheet( country ) reference
I asppreciate any answers to this as atthe moment I've spent the better part
of a day changing sheet references
...Report Generation Variables for Date
I'm trying to define a filter in a report, using the last month start and
last month end as low and high limits. Can somebody tell me the name of
this variables, like <Today> is self explanable.
this is all I have:
<MonthStart> first day of month
<WeekStart> date of first day of this week
<LastWeekStart> date of first day of last week
<YearStart> first day of year
<Now> current date/time
<ReportDate> date of report
"Alvaro Guzman" <email@example.com> wrote in message
news:7C2DA569-6C0C-420C-9F49-4FC...Converting Date to Beginning of the Month
I have an issue with dates. I am trying to convert any date such as
11/27/2006, 3/14/2005, to essentially only the month and year. I have a
formula that will only work correctly if all dates are the first of the
month so I need to convert the above dates to this: 11/1/2006 and
3/1/2005. Is there a way to do this? Any help would be greatly
A1 = 11/27/2006
=A1-DAY(A1)+1 = 11/1/2006
<firstname.lastname@example.org> wrote in message
> Hello All,
> I h...Copying data #3
I need help in copying data.
I have data exported from a text file and has somthing
like following format -
Main Grp: 600
Sub Grp: 11890
grp desc amount
7878 ABCDEMF 89887
Main Grp: 600
Sub Grp: 11900
grp desc amount
7900 ABCDEMF 56844
so need to copy 'grp' below alongwith the lines of data
within the group and 'sub grp' also alongside the data..
may be on right side after amount.
I tried with Edit/Go to.. and spe...combone data from more that one page
what is the easiest way (if possible)to conduct analysis of data from
more than one page
consider I have 5identical pages (one for each sales regions) with lots
of products in column a and months in row 1 with data in a table
is there anyway i can conduct analysis of the 5 sales regions as a
whole or by area
ideally i would like a pivot that had the regions as a field and the
months and products so i can look at the data in anyway poss
If you want to create a pivot table from the data, you should store it
all on one sheet, if it won't exceed the available number of rows.
Before you com...displaying multiple dates in a table
any help/advice is much appreciated.... let me explain...
i have this table w/c have multiple date/time fields... corresponding to
birthdays of people. a single record of a person contains his birthday, his
spouse's name & birthday, and also his sons/daughters names & birthdays...
now i have already done a query in w/c i can get all persons birthday to
display per month (month parameter)...
i have done a query just like the one i made above, and it will display
the spouses & sons/daughters birthday corresponding to the month i typed in.
but the query also displaye...Filter data from two worksheets from same excel file
i have a set of account numbers in 2 worksheets( created at diff dates). i
want to find out the ones which are not there in the earlier. Both worksheets
are saved in a single file. The account numbers are of 11 digits and the each
sheet contains hundreds of such account numbers
To compare entries in Column A of sheet2 with entries in Column A Sheet1
in your sheet2 (new column G) enter in first data row(say G2))
and Copy down as far as is needed
FALSE = These values are on Both Sheets
TRUE = These values Are NOT on Sheet1
> i...How can I eliminate rows that contain the same data as the row ab.
How can I compare rows in Excel aand eliminate those rows that have duplicate
information in them?
Use data>filter>advanced filter, select unique records only
"mjlucas49" <email@example.com> wrote in message
> How can I compare rows in Excel aand eliminate those rows that have
> information in them?
...conditional format -- if not a date, then highlight cell
How do I enter a conditional format to highlight the cell if it's not a valid
I tried "formula is":
Your help would be greatly appreciated!!
I think I'd put some data validation on the field to ensure that it's a date
> How do I enter a conditional format to highlight the cell if it's not a valid
> I tried "formula is":
> =if(not isdate(C10))
...date and time formating in one cell
I have the following date/time stamps in one cell:
As you can tell, the date is yyyy\m\d and time is h:mm:ss
The problem I have is the numbers appear exactly as above.
My question is how do I get the respective date and time
to show up in the cells?
Right now, I am only getting the "##############" to show
in the cells.
Thanks for your help,
Are you not inputting this data as time, that is
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email a...Wokflow email with Date field inside
I need to sent an email with Dete field and every time CRM sent Value like
"10-08-2008 00:00 (GMT+01:00) Sarajevo, Skopje, Warsaw, Zagreb"
I want sent only Date like this: "10-08-2008" nothing more... Is it possible?
Thanks for any help
As well i know you can call Assembly in workflow to change this
There's actually a Custom CRM Attribute for Time Zone. Create an Integer
(Int) field, and from the Format picklist, select "Time Zone". You'll then
see a "Default Value" picklist, where you can choose a default time...Data Validation
I am using data validation from a list in Excel 2007. When I click
the drop down arrow and the cell was previously blank, I do not see my
options. I have to scroll up to see my choices. I realize that it is
doing this because blank cells exist in my list and it jumps to the
first one when I click the down arrow, I then see what is below that
cell in the list which are more blank cells. Is there something that
I can do so that if the cell is blank, when I click the drop down
arrow, it will show me the top of the list first? I realize one work
around is to leave the top row blank. But othe...specific data points in data range
Hi all and happy new year.
Is it possible to plot certain points and then a range of data on one series
line and if so how ?
Basically I have 4 years of data (monthly) but now want to report jan & Jul
results for 2006 - 2008 and then all of 2009 data.
thanks in anticipation
...Automatic data update
I want to know whether there is such function in Ms Excel?..
For example, I have some data series consisting 100 data..and every month I
will add 1 data into the series..
And I want to create a chart showing the 10 latest data... in this regard,
every time I add a data, automatically (or by clicking some button)...the
chart will updating the data by add the new one and remove the oldest one,...
so the chart still consist the 10 latest data...
what i've been doing right now is only by dragging the data source area....
and since i will deal with more than 20 charts, this ac...How do I get total value data labels in a stacked bar chart?
I have a 3-D stacked bar chart with four series and I want to have the total
value in each category be displayed in a data label. Can I do this, and if
This should help
> I have a 3-D stacked bar chart with four series and I want to have the total
> value in each category be displayed in a data label. Can I do this, and if
> so, how??
Andy Pope, Microsoft MVP - Excel
Thanks, Andy. The CFO is thrilled.
"Andy Pope" wrote:
>...Need to import select Access data into Excel using two variables
I have a large amount of data in Access, more than Excel can manage. The
data consists of many columns; has Col_1 as unique key 1,2,3,4,5,6,7,8 etc…
and contains data that includes Col_2, Col_3, Col_4 etc….
It takes a combination of Col_2 and Col_3 to get the data I want. Col_2 has
duplicate values and Col_3 makes the subset unique.
One more thing… Col_3, Col_4 etc…may have blanks throughout the table and
can’t be changed. I don’t own it.
I want to be able to open Excel, type “Number from Col_2” into Col_A ,
“(Number fromCol_3) or (blank)”into Col_B and have the Col_4, Col_5 etc… d...Access 2007 Auto update Date
I wish to update a date automatically in a form, after data has been changed.
I have tried to do as the link belows shows, but I am not having any joy.
I do not need the time just the date.
If anyone can write what I need & give me a step by step Or a link, I would
I have no knowledge of vba so the full vba would be appreciated.
...Date Difference 02-24-10
Good Morning. I am trying to figure out how to calculate the number of days
between two dates. I have a table callled events. That table has event
date, event type, event outcome.
For example a defendant will have an Advisement Date (AA as stored in the
table) and say a Preliminary Hearing date (PH). When i enter information I
will enter the date, event type and the event outcome will be (PD for
Pending, CN for Continued, or CP for completed). For example Case Number
10-12345 will have an AA on 01/05/10 which is Completed and a Preliminary
Hearing on 02/05/10 which was C...charts with Timestamps
when plotting a chart with timestamps (9/28/05 3:05 AM) used on the X-axis,
only the 'Date' part is taken into account. The 'time' part is dropped.
When converting all timestamp to numbers (e.g. 38623,.12876) then of course
the chart is plotted correctly. How can I have a continuous timeline where
date and time are taken into account on a chart ?
A time scale axis of a line chart only considers whole numbers (i.e., days,
not times). You need to make an XY chart, not a line chart. Note that the
terminology is misleading: either type chart can have any combination of
...Help, please: to move data from OExpress 6 to O2000 ?
On a pretty good Win XP PC, I need to upgrade from Outlook Express 6 to
Outlook 2000. I installed Outlook and it imported all the
folders/messages/identities from OE6. Outlook 2000 starts up, and all seems
fine, and I'm looking at the new message that it created... "Welcome to
Outlook 2000". If I try to view any other message, it locks up. I see the
perpetual hourglass. It's dead.
So, I installed Outlook 2000 on another XP PC, created a mail account, and
it seems to work fine. I can read and send messages. Cool.
How can I export all of the folders/me...