grouping dates by week/month/etc. on cat. axis
I just want to group my dates in a pivotchart by months or weeks to get
sales or weight sums by the month or week. Problem is that the chart won't
allow me to group the dates--it says that this type of data cannot be
grouped. why? why? why?
the dates in the cells also have time info:
7/1/2004 9:53:07 AM
so when I put the Date field into the Category area of the chart it plots
every row down to the second! I'm lost and confused and searched the whole
newsgroup but can't find any postings of this same issue.
it seems like something common. can anyone help?
I am trying to automatically print sequential numbers on individual
cards on 8.5" x 11" business card stock (to create tickets) using MS
Publisher and cannot figure out how to get it to do this. Does anyone
know the secret? Thanks.
Hi Scott (email@example.com),
in the newsgroups
|| I am trying to automatically print sequential numbers on individual
|| cards on 8.5" x 11" business card stock (to create tickets) using MS
|| Publisher and cannot figure out how to get it to do this. Does
|| anyone know the secret? Thanks.
Check out the following tutorial:...Multiple rows, same date, multiple start/end times... how might I...
I have a workbook that has a sheet with:
multiple consecutive rows each have the same date.
then the date changes for another set of consecutive rows like this (pastes
excel cells below - hope you can see it?).
Date Start Time End Time Daily Total Running Total
Friday, August 01, 2003 8:00 AM 11:00 AM 3.00 3.00
Friday, August 01, 2003 11:00 AM 11:30 AM 0.50 3.50
Friday, August 01, 2003 12:00 PM 2:15 PM 2.25 5.75
Friday, August 01, 2003 2:15 PM 4:30 PM 2.25 8.00
Friday, August 01, 2003 4:30 PM 6:00 PM 1.50 9.50
Wednesday, August 06, 2003 8:00 AM 9:00 ...Auto formula when putting in date
I have a workbook where, when I enter a date such as
11/30, Excel automatically puts an = in front of it,
yielding a value I don't want. I have several sheets in
the workbook and they all do the same thing. The only way
I can get the cell to look like a date is to put a "'" in
front of it and then it doesn't act like a date (i.e., I
can't use it in a different formula to compare the date).
Other workbooks will automatically format the cell as a
date and do not put the = sign in front. I can put a date
in the other workbook, paste it into the cell in the fi...Cannot set task start or end date!!!
For some reason I can no longer set up task start or end dates. When I open
the drop down list, it will not stay open when I release the left click. I
can hold down left click and choose a date, but if I want to choose the
"today" or "none" radio buttons, that will not work. Any ideas?? I am also
using the Xobni program with Outlook, but do not have this problem with the
same config. at home. I can set the status, priority and % complete fields
with absolutely no problem.
Does it work in Outlook Safe Mode?
Start-> Run; outlook.ex...Yesterday's Date
I'm trying to pull data for today or yesterday's date. I'm using the
query below to pull todays date, but would like to add an OR statement
WHERE license_datetime = (SELECT CONVERT(VARCHAR(8), GETDATE(), 1)
The above statement is working. I tried running the statement with a
-1 instead of , but it's invalid. What the correct way to do this?
The best is to use a half-open interval and the date/time functions to set the time at midnight. See the f...count dates
How do I count then rows where the date is within a certin month ?
A B C
1 xxx some text 01-01-2005
2 yyy some text 31-01-2005
3 zzz some text 01-02-2005
4 vvv some text 01-03-2005
6 Number of rows where month is 01 (2)
7 Number of rows where month is 02 (1)
8 Number of rows where month is 03 (1)
Thanks in advance.
One way would be
=SUMPRODUCT(--(MONTH(C1:C4)=1)) for January
You could put month numbers 1 - 12 in cells D1:D12 then enter in E1
then copy down through E2:E12
Change...Receipt / Invoice printing Terms & Due date
We do a lot of charging on customer accounts. Is there a way to show the
Terms and the Invoice due date on each invoice / receipt?
Thanks in advance,
The only way I have been able to accomplish this is by putting the
terms into a customer custom text field and printing that on the
receipt. We then created a customization that will populate a receipt
variable with the current date + the number of days in the terms. I
have not been able to use any other receipt variable to get this to
New West Technologies
Check out amazing RMS extensions:
http:...How to create a date mask and drop down list?
I am not sure if this is the proper wording, but is their anyway t
create a standard date function/mark, to type dates in without havin
to type DASH, having to type out the entire year etc....
Also how can I create a drop downlist to choose from (that show
results when I type the first letter or second letter) in a column?
Any help with this would be greatly appreciated thanks
Nikos's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=986
View this thread: http://www.excelforum.c...Current Date Marker
I have a calculated chart of price vs date and would like
to create a vertical line indicating current date so that
the progress can be easily checked. Have been unable to
find out how to create a vertical pole. Can someone help?
have a look at
> I have a calculated chart of price vs date and would like
> to create a vertical line indicating current date...After Up-date
This is probably a Access 101 question, but here goes! I have an issue with
my form that when a user updates a field, and then goes to navigate away to a
different record using a drop down, we get a error message. I know what it
is, the entry has not, been saved, the record is still in edit mode.
Is there a common practice that can eliminate this, and after-up-date
command or something?
Up-dating any sub form fields work fine, just fields on the parent table /
Any help is appreciated.
On Thu, 4 Feb 2010 06:33:01 -0800, CB <CB@discussions.microsoft.com> ...Controlling Sequential Numbers
I have been researching using sequential numbers for invoices an
purchase orders, but all of them seem to advance the number eithe
every time the document is opened or saved. My purchase order is par
of a larger file, and since I will be opening and saving the fil
without necessarily writing a purchase order I need more control ove
its advancement. I was wondering how I could create a button that whe
pressed or selected would advance the number by 1? Also, how could
make it create a unique number depending on who's creating the purchas
order. For example, let's say the user is ...Date problem
Having problem to bring the date into string. Currently, I have to declare
@cp_dt in sql string where @cp_dt is within the quote. I dont want to
re-declare @cp_dt (double work). Is there any other way to do the following
declare @cp_dt datetime,
set @cp_dt = (select top 1 position_date from glob.dbo.cp order by
set @cp_dt_cv = convert(varchar(10),@cp_dt,103)
set @cp_dt_txt = replace(@cp_dt_cv,'/','')
set @cp_file = (select right(lt...how do i change dates on my calendar and keep my pics
Publisher doesn't support this. You would need to do it manually.
Microsoft Publisher MVP
~pay it forward~
This posting is provided "AS IS" with no warranties, and
confers no rights.
"Bob T" <Bob T@discussions.microsoft.com> wrote in message
...Bizarre Excel Copy/Paste Date Issue
I'm working on 2 xls Excel 2000 files (with all Office Updates and Windows
Updates applied on this WinXP PC). I'm copying a date from a cell in A.XLS
and pasting it into B.XLS. Both cells are formatted as dates. I copy the
1/1/1999 from A.XLS but when I paste it into B.XLS, it shows up as 1/1/1994.
There are NO formulas involved and I have auto-calculation ON. They are not
text, they are true date entries.
I've never seen anything like this and wouldn't know where to look for help
on this except for here.
Any suggestions greatly appreciated.
One work...Date Format #8
I have a column of dates in the format xx.yy.zzzz. I want them to be displayed as the format xx/yy/zzzz. The cell format custom option does not convert the date from one to the other. How can I do this?
"Ron Cardy" <firstname.lastname@example.org> wrote in message
> I have a column of dates in the format xx.yy.zzzz. I want them to be
displayed as the format xx/yy/zzzz. The cell format custom option does not
convert the date from one to the other. How can I do this?
At the moment, you actually have text strings...Next sequential number on a different form
Is there a way to do this:
I have a form called "List of Proposals Written" that is listed by th
Is there a way to display on another excel spreadsheet, the mos
current Proposal number?
I know Access you use something like Dmax(ProposalID)+1
What should I do in Excel:confused:
Any help would be greatly appreciated!
Message posted from http://www.ExcelForum.com
"daniels012 >" <<email@example.com> wrote
> I have a form called "List of Proposals Written" that is listed by the
> Propos...Problems with date and time on Notes.
I have just started using Outlook Notes. I note (no pun intended) that the
date and time on some Notes updates to the current date and time each time I
open it. How can I fix things such that the date and time remains set at
the date and time the Note was created?
Got it. Do it in the code, don't try to do it in FP.
"Chris Mitchell" <chris.a.mitchell@NOSPAMbtinternet.com> wrote in message
>I have just started using Outlook Notes. I note (no pun intended) that the
>date and time on some Notes updates to the ...Is there any way to organize this forum by date?
Hi. My listing for this forum (All threads) shows the last three responses
(at the top) as variously 4/30/2006, 11/4/2009 and then 1/14/2004.
Entries for 2010 come further down.
Is there a way to organize this more helpfully?
> Hi. My listing for this forum (All threads) shows the last three responses
> (at the top) as variously 4/30/2006, 11/4/2009 and then 1/14/2004.
> Entries for 2010 come further down.
> Is there a way to organize this more helpfully?
Yes but you need to cl...Find missing sequential numbers
Hello, I'm looking for a way to quickly find what numbers are missing in
column B. I can sort them ascending, but how do I find if there are missing
I need to know 4 and 8 are missing.
select B2:Bx. Choose Format/Conditional Formatting...
CF1: Formula is =(B2-B1)>1
Format1: <pattern>/<some color>
or, without sorting, select column B (with B1 active):
CF1: Formula is =AND(B1>MIN(B:B),COUNTIF(B:B,B1-1)=0)
Both CF's will activate if there are missing numbers before them.
In article <28706E9E-2624...Date Wont Display As Date
This is a simple one, I hope.
Here is the problem formula:
I am trying to get this formula to show as:
Instead I get:
Any ideas on how to get the date to show and not the date code?
Pick one of your liking.
"Minitman" <firstname.lastname@example.org> wrote in message
> This is a simple one, I hope.
> Here is the problem formula:
Im trying to do somthing that I am guessing is quite simple.
Im working on a Db that tracks a fleet of rental skiis. Every 2 years these
skis must be tested.
I have a table that tracks all the information about a given pair of skis,
including the date they were last tested. What I am trying to do is have a
feild within that table autocomplete using the [test date] feild, plus 2
years. This new feild would then become the date when the next test was
The Table is called [Ski Info]
The first date feild is [Test date]
the feild I would like to have calculated is [Next te...future dates in payables
An end user accidentally entered payables transactions in future dates such
as 2229. We do not want to have to create fiscal periods for years so far in
the future. But, if we have to, we will.
Anyway, how would we void or get rid of transactions accidentally entered
with future periods?
Why can't you just delete the transaction? You can't post to a period
that hasn't been setup.
East Coast Dynamics
The client says that there are some transactions in the system like that that
she cannot...X axis date
I'm using Excel '97 (Yeah, I know, but it's all I can afford at the moment)
I want the X axis to always display a month beyond the latest date, so
that the line graph stops short of the right hand side.
I can get the Y Axis of value to stay ahead of the game by a consistent
amount, but the date defaults back to the latest date when Auto for Max
value is ticked.
Is this possible? Will I have to use VBA?
Please clue me in.
Add a series to the chart. It can consist of a single point, where the date
is calculated as the maximum in your date column plus 30, an...Date Increase
I currently have a form for entering current passwords for systems. I have a
field to enter the date the password was last changed, and another field for
the date the password expires, which is every 30 days.
Is there anyway i can set the date password expires field to update
The 2nd field is just calculated from the 1st and better left as a
calculation in a query rather than a field in a table. There are no triggers
at the table level in Access.
Dan Wood wrote:
>I currently have a form for entering current passwords for systems. I have a
>field to enter...