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

(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 *