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

Yes, you are correct but in my test in Excel 2000, it produced 'c081214' and 'c081221'.


Norm Dennis

-----Original Message-----
From: pctech-bounces@xxxxxxxxxxxx [mailto:pctech-bounces@xxxxxxxxxxxx]On
Behalf Of Thorbjørn Ravn Andersen
Sent: Friday, 19 December 2008 5:10 PM
To: PC Technical Discussion for iSeries Users
Subject: Re: [PCTECH] MS Excel - Adding (n,nnn) days to a CYYMMDD date


Norm Dennis skrev:

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

C is the century. It should show up as 1 for the current century.