Increment date and publish it in next cell

[Balajibenz]

Hi Evryone,

I a new to VBA and trying to do a automation.

I Hav a user unput date which stored in a string "strdate". now i want a code that looks for the date in row 3 of sheet1 and if the date is present it has to publish strdate + 7 days in the immediate next cell to its right.

lets say user input is 10/17/2020 which is found to be in B3 then code has to put 10/24/2020 in C3. if date is not found it can ignore it.

Also if possible it has to publish the text in the format "XXX to Oct 24" in the cell C2. highlighted part of text has to be changed accoring to the date in the below cell. I am happy to have code for the first ask above.

 

[Balajibenz]

Hi Evryone,

I a new to VBA and trying to do a automation.

I Hav a user unput date which stored in a string "strdate". now i want a code that looks for the date in row 3 of sheet1 and if the date is present it has to publish strdate + 7 days in the immediate next cell to its right.

lets say user input is 10/17/2020 which is found to be in B3 then code has to put 10/24/2020 in C3. if date is not found it can ignore it.

Also if possible it has to publish the text in the format "XXX to Oct 24" in the cell C2. highlighted part of text has to be changed accoring to the date in the below cell. I am happy to have code for the first ask above.

I was able to increment it using Dateadd method. can someone help me with the part - it has to publish the text in the format "XXX to Oct 24" in the cell C2. highlighted part of text has to be changed accoring to the date in the below cell

 

[Balajibenz]

I was able to increment it using Dateadd method. can someone help me with the part - it has to publish the text in the format "XXX to Oct 24" in the cell C2. highlighted part of text has to be changed accoring to the date in the below cell

No worries, able to figure out using - "YTD to " & Format(CDate(Range(Fdate2)), "MMM DD")