Adding days to a date

[foilprint0]

Hi

Can anyone help with a formular?
I have to have dates in cells A2, A3, A4. A5 and so on in cells B2, B3
B4, B5 cells to add amount of days all will be different! in Cells C2
C3, C4, C5 I need to display what the new date would be.

Example

A2 10-aug-04
B2 23
C2 2-sept-04 result

Thanks for any hel

 

[Don Guillett]

=a2+b2
format as desired

 

[Biff]

Just add the 2 cells:

In C2, formula:

=A2+B2

Dates and times are stored as decimal numbers. The actual
value of A2 (10-aug-04) is 38209 and you're simple adding
23. 38209+23 = 2-sept-04

Biff

 

[foilprint0]

Sorted it now thank

 

[JE McGimpsey]

Since XL stores dates as integer offsets from a base date, just use
regular math:


C2: = A2 + B2

format C2 as a date.