Advice needed

[Mozelle]

I have been asked to write a macro for the attached spreadsheet. This counts the number of days each project remains in a certain status. For it to calculate the days a date
has to be inserted into the column immediately to the right of the column containing a date or a formula that would search for the next occupied cell in the row. So in the first row of this example the macro would need to search the row for the last cell with a blank cell (BB) to its right and then find the first cell in the row with a date (BE) and move it back to the first empty cell right of BC. Searching for best method to perform such a task. Spent all day yesterday reading but still unsure how to approach. Any guidance appreciated!

 

[rpaulson]

I can probably help you out, but, i don't completely understand what you are trying to do yet. Please elaborate a little more.

 

[DanteAmor]

If you have this:

Dante Amor
	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ
1	Assigned Date2	Working Date2	Validate Date2			Review Date2					Days
2	23/10/2019	24/10/2019				30/10/2019					1
3	09/01/2020	14/01/2020				14/01/2020					5
Sheet

The result after the macro would be this:

Dante Amor
	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ
1	Assigned Date2	Working Date2	Validate Date2			Review Date2					Days
2	23/10/2019	24/10/2019	30/10/2019								1
3	09/01/2020	14/01/2020	14/01/2020								5
Sheet

 

[Mozelle]

I can probably help you out, but, i don't completely understand what you are trying to do yet. Please elaborate a little more.

If the row has no date in a column following a column with a date then the date from the next column with a date needs to be moved to the left.
So on this example all of the fields that are greyed out need to be filled with the date in the next occupied column. I filled in the example on the right manually but I need to create a macro that will loop through the rows and copy and paste the dates. I'm sorry I can't explain it more clearly. Hoping the two examples help. If there was no date to the right then I used the =today() to fill in a date.