Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / May 2008

Tip: Looking for answers? Try searching our database.

Why would someone buy a microsoft product?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ATM - 23 May 2008 00:22 GMT
I was trying to auto-increment dates in Excel when I realized this was the
least intuitive program I have probably ever used in my life.  I could write
C-Code that would allow me to do it just as easy.  Why am I forced to
exchange data in excel format?  Am I going to have to make what I am trying
to make on my Linux?  Probably...

And if anyone does know how to increment dates by applying formulas, I only
spent about 10 minutes trying to figure it out and I would greatly appreciate
the help. or not.. I will probably just do it with something more user
friendly.
Pete_UK - 23 May 2008 01:07 GMT
Put a date in, say, cell A1 - format the cell how you would like to
see it.

Then in A2 put this formula:

=A1+1

The next day's date should appear in A2, and it should have picked up
the format from A1 (if not, then format A2 the same as A1 or use the
Format Painter icon).

Then copy this cell down column A as far as you would like.

Hope this helps.

Pete

> I was trying to auto-increment dates in Excel when I realized this was the
> least intuitive program I have probably ever used in my life.  I could write
[quoted text clipped - 6 lines]
> the help. or not.. I will probably just do it with something more user
> friendly.
Arvi Laanemets - 23 May 2008 06:43 GMT
And when you don't want to use formulas, but enter consequtive dates
manually, then:

a)
Enter starting two dates into column/row, then select both of them, and drag
to range you want the array of dates to enter. The date interval, you
entered with 2 starting entries, will be preserved. And Excel differs days,
months, and years. An example:

01.05.2008; 02.05.2008 :  03.05.2008; 04.05.2008; ...
01.06.2008; 11.06.2008 :  21.06.2008; 01.07.2008; ...
01.01.2008; 01.05.2008 :  01.09.2008; 01.01.2009; ...
01.01.2008; 01.01.2009 :  01.01.2010; 01.01.2011; ...

Or b)
Enter a date into cell and activate it. Now you can use the Fill feature
from menu Edit>Fill>Series with data type set to date. You can determine
ending value, date unit, and filling direction.

Signature

Arvi Laanemets
( My real mail address: arvi.laanemets<at>tarkon.ee )

>I was trying to auto-increment dates in Excel when I realized this was the
> least intuitive program I have probably ever used in my life.  I could
[quoted text clipped - 10 lines]
> the help. or not.. I will probably just do it with something more user
> friendly.
JLatham - 23 May 2008 15:16 GMT
"Why am I forced to exchange data in excel format?"
Truly forced?  Possibly (I know my company is).  Perhaps because it is a de
facto standard for many businesses and for U.S. Federal Government?  You want
to do business with them, you respond with the required files in the required
format.

"Am I going to have to make what I am trying to make on my Linux?
Probably..."  Possibly, may be easier for you in the short run - but again,
compatibility with external organizations may suffer greatly.

Just keep asking away here in these forums, and we'll keep trying to help as
much as possible.  For the time being, probably the "New Users" group would
be a good place for your questions; people won't make too many assumptions
about your knowledge of Excel or skills with it and will patiently try to
assist as much as possible.

> I was trying to auto-increment dates in Excel when I realized this was the
> least intuitive program I have probably ever used in my life.  I could write
[quoted text clipped - 6 lines]
> the help. or not.. I will probably just do it with something more user
> friendly.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.