(Solved) – vba, excel – how to add 3 months to a trimmed date


I am terrible with coding dates – I would like to add 3 months to a trimmed date. How would I go about this? Coding example below

Dim AuStart As String
Dim AuEnd As String

AuStart = Trim(HE.CurrentHost.TextRC(10, 19, 8)) 'this would be for example 12/09/19
AuEnd = ??? 'this for example if the AuStart = 12/09/19 should be 3/09/19

HE.CurrentHost.PutText AuEnd, 10, 45

Thanks all

Leave a Reply

Your email address will not be published. Required fields are marked *