So when a date is inputed on I-O 10 and so on, i want the numbers underneath the MTWTF to auto populate reflecting the days of that week only. So if i put 7-6-2020 i want it to got 6-7-8-9-10 under MWTWTF. Saturday and Sunday does not need to be populated but if it makes it easier i dont mind. Appreciate the assistance.
Brrrrr, lots of merged cellls...
I feel you! Unfortunately I am not able to recreate this document to simplify it a bit.
Why are you not able to?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Thanks for the help everyone.
Last edited by Curtis2145; 07-09-2020 at 11:38 AM.
Try the following formula in cell I12: =$I10+COLUMNS($A1:A1)-1
Set the custom formatting to d.
drag the formula across.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thank you so Much!
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks