Adding days to a date

  • Thread starter Thread starter foilprint0
  • Start date Start date
F

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
 
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
 
Since XL stores dates as integer offsets from a base date, just use
regular math:


C2: = A2 + B2

format C2 as a date.
 
Back
Top