Excel Formula Date adding help please

Matrix · 5 Jun 2009 at 23:34

I'm trying to work out how i get a Formula to work and hoping someone here wil be able to help me please.

What i need is when i put a date in the C column 01/01/2009 in column D it gives me the result by adding 150 days.

So the result would show in D column 31/05/2009.

I used this =C2:C100+150

But as soon as i put say 04/04/2009 in C3 i don't get a result in D3?

Is there a way i can set what every i put in C column i get the result in D column? Instead of having to allocate that Formula to each cell in the D column.

I just can't work it out

Thanks.

Explicit · 5 Jun 2009 at 23:46

Matrix said:
I used this =C2:C100+150

Change the D2 formula to =C2+150

Matrix said:
But as soon as i put say 04/04/2009 in C3 i don't get a result in D3?

Is there a way i can set what every i put in C column i get the result in D column? Instead of having to allocate that Formula to each cell in the D column.

Select D2, then drag the cell down from the bottom right corner to however many rows you need.

Matrix · 6 Jun 2009 at 08:29

Explicit said:
Change the D2 formula to =C2+150

Select D2, then drag the cell down from the bottom right corner to however many rows you need.

Thank you that works a treat

.

Thanks again.