Date with 10 days forward than current date.

[naveenmarapaka]

Hi.

I want to create a VBA macro. which will fill my Due_Date column with 10 days ahead than current date.

Example : Today is 1/23/2014 , My Due date should be 2/1/2014


I have 2 columns

Pick_up_date which will have today date in format(mm/dd/yyyy)

Due_Date


Pls advise the code.

[Kaper]

Current date column A, Due date column B - have a look on the code:

Please Login or Register  to view this content.

[xlbiznes]

try this code :
let us say that your pick_up_Date column is in column b then the code would be :

Please Login or Register  to view this content.

[naveenmarapaka]

Hi kaper.
I tried the same, it worked perfectly...

but I still have small prob,, my current date is with Time too..,,, so the same format is coming in due date as well
since we just added 10 to pickupdate.

but I need my due date format in mm/dd/yyyy only, exclude time.

pls advise.

[Kaper]

How about:

Please Login or Register  to view this content.

or:

Please Login or Register  to view this content.