Hello
all
If i write 6 or June or in a cell let's say A2, can I have column B populate a list of dates for the current month (june)? is ther a formula for this?
Thank you
Hello
all
If i write 6 or June or in a cell let's say A2, can I have column B populate a list of dates for the current month (june)? is ther a formula for this?
Thank you
Thanks,
R.
Try this:
=TRANSPOSE(SEQUENCE(1,DAY(EOMONTH(A1,0)),EOMONTH(A1,-1)+1))
AliGW on MS365 Beta Channel (Windows 11) 64 bit
A B 1 06/06/2022 2 3 01/06/2022 4 02/06/2022 5 03/06/2022 6 04/06/2022 7 05/06/2022 8 06/06/2022 9 07/06/2022 10 08/06/2022 11 09/06/2022 12 10/06/2022 13 11/06/2022 14 12/06/2022 15 13/06/2022 16 14/06/2022 17 15/06/2022 18 16/06/2022 19 17/06/2022 20 18/06/2022 21 19/06/2022 22 20/06/2022 23 21/06/2022 24 22/06/2022 25 23/06/2022 26 24/06/2022 27 25/06/2022 28 26/06/2022 29 27/06/2022 30 28/06/2022 31 29/06/2022 32 30/06/2022
Sheet: Sheet1
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.
Any use for you???
great thank's so much Ali!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks