Re: MS Excel - Adding (n,nnn) days to a CYYMMDD date

["Norm Dennis" <nhdennis@xxxxxxxxxxx>]

"Is the Date Format CYYMMDD a valid format in your version of excel?"

How I can determine that?

Experiment with it I guess.

In my test of your example, I right clicked on cell A1 and went to the
Format Cells entry on the pop up menu (also available from the Insert menu
on the toolbar and also the ctrl I keys).
Then checking the "Category" under the Number tab for possibilities in Date
and Custom.
I entered a custom entry CYYMMDD then hit OK.
Then I type into the formatted cell A1 to date 14/12/2008 (Australian
format)
in the cell B1 I typed in a number 7
in the cell C1 I formatted the cell with the custom entry CYYMMDD and
created the formula =SUM(A1+B1)
My result was:
Cell A1 = c081214
Cell B1 = 7
Cell C1 = c081221

HTH


Norm Dennis


-----Original Message-----
From: pctech-bounces@xxxxxxxxxxxx [mailto:pctech-bounces@xxxxxxxxxxxx]On
Behalf Of Peter_Vidal@xxxxxxxx
Sent: Friday, 19 December 2008 12:04 AM
To: PC Technical Discussion for iSeries Users
Subject: Re: [PCTECH] MS Excel - Adding (n,nnn) days to a CYYMMDD date


"Which version of excel are you using?"
I am on version 2003.

"Is the Date Format CYYMMDD a valid format in your version of excel?"
How I can determine that?

PETER VIDAL
MAPICS IT TECHNICAL SUPPORT TEAM / SR SYSTEM ANALYST
10540 Ridge Rd., Suite 203, New Port Richey, FL 34654-5111
Tel:727-849-9999, x2414 Fax:727-815-3120
WWW.PALL.COM

"I am certainly convinced that it is one of the greatest impulses of
mankind to arrive at something higher than a natural state."
James Baldwin

----------------------------------------------------------------------------
----

Attention:

This communication may contain information that is confidential,
privileged and/or exempt from disclosure under applicable law.
If you are not the intended recipient, please notify the sender
immediately and delete the original, all attachments, and all
copies of this communication.


----------------------------------------------------------------------------
----
--
This is the PC Technical Discussion for iSeries Users (PcTech) mailing list
To post a message email: PcTech@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/pctech
or email: PcTech-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/pctech.

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.176 / Virus Database: 270.9.19/1855 - Release Date: 12/18/2008
10:16 AM