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
Sanjay GandhiFounder, KenhalAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
you may customize this.
0
Sanjay GandhiFounder, KenhalAuthor Commented:
Means:
Use regular steps
- insert rows
- copy dates down

or, something else??
0
ShumsExcel & VBA ExpertCommented:
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
0
Acronis True Image 2019 just released!

Create a reliable backup. Make sure you always have dependable copies of your data so you can restore your entire system or individual files.

Ryan ChongBusiness Systems Analyst , ex-Senior Application EngineerCommented:
ooops, i thought i have uploaded mine.

try this as well, another approach.
Month-Dates_b.xlsx
0
Rob HensonFinance AnalystCommented:
A simple approach in the attached.

Enter 1st of month in B4 and then this formula in B5 and copied down to row 127 (124 rows for 31 x 4 for each date):

=IF(COUNTIF(B$4:B4,B4)<4,B4,IF(MONTH(B4+1)=MONTH(B4),B4+1,""))

Checking the month of day +1 allows for the months with less than 31 days.

Thanks
Rob
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Sanjay GandhiFounder, KenhalAuthor Commented:
Thanks.
0
ShumsExcel & VBA ExpertCommented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Office

From novice to tech pro — start learning today.