Automatically fill in other cells based on two dates

[gvijaygadde]

Hi,

I am trying to write VBA code for my Excel sheet project management sheet.

Example like this: In Column
A1 - Project start date
B1 - Project end date
C1 - Number of days between these two dates - got the formula
Range("A3").Value = DateDiff("d", Range("A1").Value, Range("A2").Value)
D1 - Number of weeks between these two dates
Range("A4").Value = DateDiff("w", Range("A1").Value, Range("A2").Value)

But now my problem, when start adding dates in next rows the above steps on [C2, D2] [C3,D3] should automatically happend fill the values in based on [A2,B2], [A3,B3] respective colums

How can i automatically incriment the Cell referance value.

Many thanks for your and I really appritiate a quick response on this.

Thanks in advance,
Regards,VJAY.