Today function

[John Davis]

Hello All:

Can someone help with the following:

Range ("B3").Value = "=TODAY() + 5 WEEKS"

Not sure how to add the 5 weeks to TODAY.

 

[VoG]

Try

Range("B3").Value = Date + 35

 

[John Davis]

Try

Range("B3").Value = Date + 35

Thanks for your reply VoG. This works just right.