Calculating dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

countrygirl0712 - 17 Mar 2008 22:10 GMT

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.

Reply to this Message

David Biddulph - 17 Mar 2008 22:45 GMT

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

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

Reply to this Message

Gary''s Student - 17 Mar 2008 22:46 GMT

In A1 put:

=B1+7

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

Signature

Gary''s Student - gsnu200774

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

Reply to this Message

Tyro - 18 Mar 2008 18:20 GMT

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

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

Reply to this Message