Calculating dates

[countrygirl0712]

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.

 

[David Biddulph]

In A2, use the formula =B2+7

 

[Gary''s Student]

In A1 put:

=B1+7

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

 

[Tyro]

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