I want to create a formula so that when I enter a date in one column and a
number value in another column it adds the date and the number value and
automatically populates the adjacent cell with a calculated date.

For example:
08/20/08 + 4 = 08/24/08

Just add them

=A1+B1

--


Regards,


Peo Sjoblom

"Gaza" wrote in message
...
I want to create a formula so that when I enter a date in one column and a
number value in another column it adds the date and the number value and
automatically populates the adjacent cell with a calculated date.

For example:
08/20/08 + 4 = 08/24/08

Hi,

I tried that and get #VALUE! what am I doing wrong? I am using Excel2003.

Thanks,

Tuukka

"Peo Sjoblom" wrote:

Just add them

=A1+B1

--


Regards,


Peo Sjoblom

"Gaza" wrote in message
...
I want to create a formula so that when I enter a date in one column and a
number value in another column it adds the date and the number value and
automatically populates the adjacent cell with a calculated date.

For example:
08/20/08 + 4 = 08/24/08

=A1+b1

"Gaza" wrote:

I want to create a formula so that when I enter a date in one column and a
number value in another column it adds the date and the number value and
automatically populates the adjacent cell with a calculated date.

For example:
08/20/08 + 4 = 08/24/08

Gaza wrote:
I want to create a formula so that when I enter a date in one column and a
number value in another column it adds the date and the number value and
automatically populates the adjacent cell with a calculated date.

For example:
08/20/08 + 4 = 08/24/08


Have you tried anything yet? Try looking at "Add dates" in the help file.

"Glenn" wrote:

Gaza wrote:
I want to create a formula so that when I enter a date in one column and a
number value in another column it adds the date and the number value and
automatically populates the adjacent cell with a calculated date.

For example:
08/20/08 + 4 = 08/24/08


Have you tried anything yet? Try looking at "Add dates" in the help file.
Yes, I tried the date plus the the number value and it works fine but is there a formula that will automatically populate the new date value once I enter the number value. for instance if I have 08/20/08 in one cell and I enter 4 in another cell how can I have 08/24/08 appear automatically in the adjacent cell without having to create the formula in that adjacent cell? Is there an "If" formula we can use?

Gaza

"without having to create the formula"

You actually asked for a formula in the first place and you received 3
correct answers.

--


Regards,


Peo Sjoblom

"Gaza" wrote in message
...


"Glenn" wrote:

Gaza wrote:
I want to create a formula so that when I enter a date in one column
and a
number value in another column it adds the date and the number value
and
automatically populates the adjacent cell with a calculated date.

For example:
08/20/08 + 4 = 08/24/08


Have you tried anything yet? Try looking at "Add dates" in the help
file.
Yes, I tried the date plus the the number value and it works fine but is
there a formula that will automatically populate the new date value once
I enter the number value. for instance if I have 08/20/08 in one cell and
I enter 4 in another cell how can I have 08/24/08 appear automatically in
the adjacent cell without having to create the formula in that adjacent
cell? Is there an "If" formula we can use?

Gaza

Gaza wrote:

I want to create a formula so that when I enter a date in one column and a
number value in another column it adds the date and the number value and
automatically populates the adjacent cell with a calculated date.

For example:
08/20/08 + 4 = 08/24/08


"Glenn" wrote:

Have you tried anything yet? Try looking at "Add dates" in the help file.

Gaza wrote:

Yes, I tried the date plus the the number value and it works fine but is there
a formula that will automatically populate the new date value once I enter the
number value. for instance if I have 08/20/08 in one cell and I enter 4 in
another cell how can I have 08/24/08 appear automatically in the adjacent cell
without having to create the formula in that adjacent cell? Is there an "If"
formula we can use?

Gaza

If you are suggesting you want the result cell to be blank until both the date
and number value are entered, where A1 is the cell with the date and B1 is the
cell with the number value, try this in C1:

=IF(AND(ISNUMBER(A1),ISNUMBER(B1)),A1+B1,"")

If that's not what you are looking for, try describing it again, including how
these solutions don't meet your needs.