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]
