Can you attach a file that shows an example of what you're seeing? Or
else send it to me directly?
Like I said, the formula seems to work fine when I started up a new Calc
file and entered the information. So it might be helpful to see your
actual file (take out anything that might be confidential before sending
it, of course, or else just start up a new file and put in what you're
talking about in cells A1, B1, and C1.
Walter Hildebrandt wrote:
I do not have an asterisks in the formula. Somehow the asterisks was added
to what I said in the Email. When I enter =A1+3 in Cell B1, I get Jan 02,
00
On Tue, Sep 29, 2009 at 9:51 AM, Richard Detwiler <[email protected]> wrote:
Walter Hildebrandt wrote:
How is the following done?
Cell A1 has a date
Cell B1 is to have the date that is in A1 but the date in B1 is three days
latter that the date in A1
Cell C1 is to have the date that is in B1 but the date in C1 is eight days
latter that the date in B1
All the cells are formatted as Dec 31, 99
Entering either *=A1+3* or =*A1+3* in Cell B1 produces Jan 2, 00 but
the
date in A1 is a September date
Walter
Denver
Colorado
I don't understand what the asterisks are for in your formulas.
When I enter today's date (9/29/09) in A1, and the enter the formula =A1+3
in B1, the result is 10/02/09, like it should be. And when I enter =A1+8 in
cell C1, the result is 10/07/09, like it should be.
Have you tried entering the formulas without the asterisks?
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
