Add Weekdays, in column A and after every Thursday add a blank row

Hi,

we have a database where we are trying to add weekdays in column A and after that it will add blank row if its Thursday

Process is
1. Add a column A
2. Start adding weekdays
3. Add a blank row after every Thursday
4. We required only following weekdays

Friday
Monday
Tuesday
Wednesday
Thursday

if there is no data in weekday it will be blank row

we have also attached a demo data sheet with result sheet
Sheet1 is data sheet and Sheet2 is result sheet

advice pls

Your first date, 8th April 2021, is actually a Thursday. Do you want your table to start with the earliest date in your data, or should it always start with a Friday?

Are you looking for a macro to do this?

Pete

Thanks rollis13,

you have done a great work for me. thank you very much

can we make the below WEEKDAYS SERIES default, please check sheet2!A2:A6 in thread #1

Friday
Monday
Tuesday
Wednesday
Thursday

if there is no data in a day, that raw will be blank

You haven't replied to @Pete_UK question and I would also point out that 11-apr and 18-apr are Sundays, how are they to be treated.

I was going to propose a formula-based solution, with the starting point being the earliest date in your data, which I then discovered was a Thursday, so I was asking you if you wanted to start with that, in which case you would have:

Thursday ... 08-04-21

Friday ... other dates ...
Monday
Tuesday
Wednesday
Thursday

and so on, or did you always want to start with a Friday, in which case you would have:

Friday
Monday
Tuesday
Wednesday
Thursday ... 08-04-21

Friday ... other dates ...
Monday
Tuesday
Wednesday
Thursday

However, you seem to want a VBA solution, so I'll duck out of this one.

Pete

Hi Pete_UK

thanks for your effort and time to give my post

we have got the vba from rollis13 its working, we just want some modification now

We have just checked and now know my demo data start with Thursday, no problem after Thursday we will add a blank cell and start the new data from Friday

if my first filled data start with Wednesday, then it will be Wednesday, Thursday and after giving a blank row my next data will be start from Friday

If my first filled data start with Tuesday, then it will be Tuesday,Wednesday, Thursday and after giving a blank row my next data will be start from Friday

If my first filled data start with Monday, then it will be Monday, Tuesday,Wednesday, Thursday and after giving a blank row my next data will be start from Friday

If my first filled data start with Friday, then it will be Friday, Monday, Tuesday,Wednesday, Thursday after Thursday we will give the blank row

Thanks rollis13 for the help, its working perfectly

only one query is left and that is
in the weekdays serial
Friday
Monday
Tuesday
Wednesday
Thursday

if we have not data in a day then that row will be blank
as we have done in given sheet2!A2:A6 in thread #1
you can check in range Sheet2!A5, there is no data but we have that days

thank you very much for the help, pls check if the above format we can implement ,

we have created a new sheet with result data and highlighted the cells with blue colour where we have no data and its blank, we required this format, (if you see you can understand my point, its the perfect sheet for me))

Not everything is clear since you didn't answer my question in post #9, therefore, my feedback will be by intuition.
If you only need a standalone macro to color your no-data rows use this applyed to your lastest file post #10:

Please Login or Register  to view this content.

In the meantime I have updated my previous macro post #9 to the new layout and to manage missing dates and also to color no-data rows, have a try:

Please Login or Register  to view this content.

Hi, thanks , checked with the code but there is some problem

request you to pls check once

pls

i have used the sheet of thread #10

and below code

HTML Code: 

ok, i m going to create a new thread,

with the fresh sheets to avoid misunderstanding.

thanks,

meet you in next post

thanks thanks thanks thanks rollis13

created new thread, marking this thread as solved.

my new thread is
https://www.excelforum.com/excel-pro...ml#post5457397