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] > >
