Calculating Dates

[Gaza]

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

 

[Peo Sjoblom]

Just add them

=A1+B1

--


Regards,


Peo Sjoblom

 

[Mike H]

=A1+b1

 

[Glenn]

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.

 

[Gaza]

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

 

[Peo Sjoblom]

"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

 

[Glenn]

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.

 

[Tuukka]

Hi,

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

Thanks,

Tuukka