Calculating dates
 

I want column a to take column b and come up with the date that would be 7
days after the date in col b. Is there any way to do that? Thanks for any
help you can give me.

Calculating dates
 

In A2, use the formula =B2+7
--
David Biddulph

"countrygirl0712" wrote in
message ...
I want column a to take column b and come up with the date that would be 7
days after the date in col b. Is there any way to do that? Thanks for
any
help you can give me.

Calculating dates
 

In A1 put:

=B1+7

so if B1 shows: 3/17/2008 then A1 will show 3/24/2008

--
Gary''s Student - gsnu200774


"countrygirl0712" wrote:

I want column a to take column b and come up with the date that would be 7
days after the date in col b. Is there any way to do that? Thanks for any
help you can give me.

Calculating dates
 

Excel's dates are numbers. Excel's date range is Jan. 1, 1900, day 1 through
Dec. 31, 9999, day 2,958,465. March 18, 2008 is day 39,525. When you format
the number 39525 as mm/dd/yy you will see 03/18/08. So, since Excel's dates
are simply numbers, you can do anything with them that you can do with
numbers.

Tyro

"countrygirl0712" wrote in
message ...
I want column a to take column b and come up with the date that would be 7
days after the date in col b. Is there any way to do that? Thanks for
any
help you can give me.