Richard, you solved the problem. I opened a new spreadsheet, formatted the cells to dates and enter a date in A1. Cell B1 came up with Jan 2, 00. I then entered the date in A1 as 9/29/09 and it worked. The problem was that in A1 I was typing Sept 29, 09 as the date so I was not actually entering a date in A1.
Thank you Walter Denver CO On Tue, Sep 29, 2009 at 10:22 AM, Richard Detwiler <[email protected]> wrote: > 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] > >
