automatically fill all dates of currant month

[Jagat Pavasia]

dear sir,
I have date typed of all dates of currant month.

I want that all date is auto update to currant month.
My A4 to A19 and E4 to E19 have date area which I typed Manually.

currant month is April 2023 (dd/mm/yyyy).

I want that if next month JUNE 2023 will come and automatically date update of currant June Month,
and next July ,August ,September, October etc...

Give me formula or VBA for this..

thank you

 

[Peter_SSs]

currant month is April 2023

Not by my calendar or your sample data.

Try these

23 05 14.xlsm
	A	B	C	D	E
4	1/05/2023				17/05/2023
5	2/05/2023				18/05/2023
6	3/05/2023				19/05/2023
7	4/05/2023				20/05/2023
8	5/05/2023				21/05/2023
9	6/05/2023				22/05/2023
10	7/05/2023				23/05/2023
11	8/05/2023				24/05/2023
12	9/05/2023				25/05/2023
13	10/05/2023				26/05/2023
14	11/05/2023				27/05/2023
15	12/05/2023				28/05/2023
16	13/05/2023				29/05/2023
17	14/05/2023				30/05/2023
18	15/05/2023				31/05/2023
19	16/05/2023
Current month

Cell Formulas
Range	Formula
A4:A19	A4	=SEQUENCE(16,,TODAY()-DAY(TODAY())+1)
E4:E18	E4	=LET(td,TODAY(),SEQUENCE(DAY(EOMONTH(td,0))-16,,td-DAY(td)+17))
Dynamic array formulas.

 

[Herakles]

Or this:

Combinations.xlsm
	A	B	C	D	E
4	01/05/2023				17/05/2023
5	02/05/2023				18/05/2023
6	03/05/2023				19/05/2023
7	04/05/2023				20/05/2023
8	05/05/2023				21/05/2023
9	06/05/2023				22/05/2023
10	07/05/2023				23/05/2023
11	08/05/2023				24/05/2023
12	09/05/2023				25/05/2023
13	10/05/2023				26/05/2023
14	11/05/2023				27/05/2023
15	12/05/2023				28/05/2023
16	13/05/2023				29/05/2023
17	14/05/2023				30/05/2023
18	15/05/2023				31/05/2023
19	16/05/2023
Sheet2

Cell Formulas
Range	Formula
A4	A4	=DATE(YEAR(TODAY()),MONTH(TODAY()),1)
A5:A19,E5:E15	A5	=A4+1
E4	E4	=A19+1
E16:E19	E16	=IF(MONTH(MAX($E$4:$E15)+1)=MONTH(TODAY()),$E15+1,"")

 

[Peter_SSs]

I used an overly complex formula for column E above. New suggestion here.

23 05 14.xlsm
	A	B	C	D	E
4	1/05/2023				17/05/2023
5	2/05/2023				18/05/2023
6	3/05/2023				19/05/2023
7	4/05/2023				20/05/2023
8	5/05/2023				21/05/2023
9	6/05/2023				22/05/2023
10	7/05/2023				23/05/2023
11	8/05/2023				24/05/2023
12	9/05/2023				25/05/2023
13	10/05/2023				26/05/2023
14	11/05/2023				27/05/2023
15	12/05/2023				28/05/2023
16	13/05/2023				29/05/2023
17	14/05/2023				30/05/2023
18	15/05/2023				31/05/2023
19	16/05/2023
Current month

Cell Formulas
Range	Formula
A4:A19	A4	=SEQUENCE(16,,TODAY()-DAY(TODAY())+1)
E4:E18	E4	=SEQUENCE(DAY(EOMONTH(TODAY(),0))-16,,A19+1)
Dynamic array formulas.

 

[Jagat Pavasia]

I used an overly complex formula for column E above. New suggestion here.

23 05 14.xlsm
	A	B	C	D	E
4	1/05/2023				17/05/2023
5	2/05/2023				18/05/2023
6	3/05/2023				19/05/2023
7	4/05/2023				20/05/2023
8	5/05/2023				21/05/2023
9	6/05/2023				22/05/2023
10	7/05/2023				23/05/2023
11	8/05/2023				24/05/2023
12	9/05/2023				25/05/2023
13	10/05/2023				26/05/2023
14	11/05/2023				27/05/2023
15	12/05/2023				28/05/2023
16	13/05/2023				29/05/2023
17	14/05/2023				30/05/2023
18	15/05/2023				31/05/2023
19	16/05/2023
Current month

Cell Formulas
Range	Formula
A4:A19	A4	=SEQUENCE(16,,TODAY()-DAY(TODAY())+1)
E4:E18	E4	=SEQUENCE(DAY(EOMONTH(TODAY(),0))-16,,A19+1)
Dynamic array formulas.

THANK YOU SOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO MUCH.....

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.