Help with dates

[JHogan0721]

Alright guys, I'm pretty new to VBA and am working on a fairly simple userform to display data from multiple sheets in one place.

I need help with one aspect, I need to convert days of the week to actual dates. The trick is I need to find the next available day of the week based on today's date. This sounds confusing so I have an example.

This is for a product ordering system.

I want to display an order process date and a warehouse pull date.

In the example - today refers to the day I'm entering the order and will not be displayed in the userform.

Ex: If I am entering an order today and it processes on a wednesday I need the display to show the date of the next wednesday after today

If the order pull day is friday then I need to display the date of the next friday following the order day.

Both process and pull days will be pulled from a worksheet with a vlookup and are defined in the worksheet only by the day of the week.

Thanks in advance

 

[James006]

Hello,

Would a simple + 7 do the job ...

 

[JHogan0721]

Unfortunately it wont work. The issue would be if I entered an order on monday and it processed on a tuesday, I would want the date to show for tuesday. For example: i input an order on Monday 1/1, the order processes on a tuesday so 1/2 would be the next available tuesday. I would want to have 1/2 auto populate as the date. Again, both process and pull day are only defined by day of the week within the master sheet.

 

[MARK858]

When you enter the date what is in the sheet to show the actual processing day? Cell references and ideally a sample of your data would also help.

 

[James006]

Hello,

Why not applying the +7 to your ' processed date ' ...