Repeat every month date four times.
Hello,
I want to repeat every date in a month four times. This exercise is required every month. How can I do it easily every month without a macro. As given in the file.
Sanjay.
Month-Dates.xlsx
I want to repeat every date in a month four times. This exercise is required every month. How can I do it easily every month without a macro. As given in the file.
Sanjay.
Month-Dates.xlsx
Ryan Chong
you may customize this.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Hi Sanjay,
Check attached, change year and month from drop-down in B1 & B2, get expected result in yellow highlighted cells.
Sanjay_Month_Dates.xlsx
Check attached, change year and month from drop-down in B1 & B2, get expected result in yellow highlighted cells.
Sanjay_Month_Dates.xlsx
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thanks.
Hi Sanjay,
Have you tried my solution?
Ryan's solution is just for current month and for Rob's solution you need to enter first date, as per my solution you can select any year or any month and you gets the result.
Anyway, you should have elaborated how both accepted solution helped you even yours you selected as assisted solution.
Attached is using Rob's solution:
Sanjay_Month_Dates_2.xlsx
Have you tried my solution?
Ryan's solution is just for current month and for Rob's solution you need to enter first date, as per my solution you can select any year or any month and you gets the result.
Anyway, you should have elaborated how both accepted solution helped you even yours you selected as assisted solution.
Attached is using Rob's solution:
Sanjay_Month_Dates_2.xlsx