Inserting an IF Formula using VBA

[tlrobinson512]

Hello everyone! I am trying to insert the following formula into my current code:

=IF(B2="","",B2+30)

This formula is pulling the date entered into cell C2:C and responding in D2:D by adding 30 days to that date.

I am not sure how to do this. Can anyone help?! What I am wanting is for the workbook to check column "C" each time it is opened. If there is a date in that column, then this formula would take place.

Any help would be appreciated! Thanks!

 

[Andrew Poulsom]

Record a macro while entering the formula manually and you will get some VBA code.

 

[asking]

Try this in your code (macro)

If Range("B2") <> "" Then
Range("C2") = Range("B2")
Range("D2") = Range("B2") + 30
End If

Cheers