I have table like below. however, doing the date manually is tough for every month. the date is shown from the start day of the week till last day of week (Mon to Sun). Example: below is week 1 so it will show like below (Mon and Tue not show any date because it was in Jan).
so when change to Week2 it shows like below
same for week3 till week5 (base on our calendar)
i try to figure out using formular but it started to get complicated and going nowhere. it would be the best if everyone can help with VBA.
Week1 | ||||||
Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |
1-Feb-23 | 2-Feb-23 | 3-Feb-23 | 4-Feb-23 | 5-Feb-23 |
so when change to Week2 it shows like below
Week2 | ||||||
Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |
6-Feb-23 | 7-Feb-23 | 8-Feb-23 | 9-Feb-23 | 10-Feb-23 | 11-Feb-23 | 12-Feb-23 |
same for week3 till week5 (base on our calendar)
i try to figure out using formular but it started to get complicated and going nowhere. it would be the best if everyone can help with VBA.