I have the following code to save a worksheet as a pdf when the button is pressed:
After 2. Folders\ I need the filename to be in this format but for the date 2 days after the current date:
2017\04 Apr\09 Apr **and whatever is in Worksheet "ATO Days", cell D2**
I tried putting the formatted dates into different cells on the sheet "ATO Days" (see attached) and referencing them for the filename, but to no avail.
I am very new to VBA.
Thank you for the help.