hope you are well. Happy new year to you all.
very quick question : please can someone help me with the coding. I'm trying to achieve the following to have date & day.
- In Cell A1 -> Month there i.e. January
- I want in Cell B3 to B32- auto fill each date in dd/mm/yy format i.e. from 01/01/2020 to 31/01/2020
- I want in Cell B4 to B34 - it auto fill days for the above dates
However, it should stops after the last day of the month.
I'm sure for all of you it's the simplest thing and I'd really appreciate your help.