remove date if it goes over current month chosen

[oblix]

Sorry for poor Heading but was not sure to call it.

In cell a1 I have a date (month and year)

in row 5 starting from column b I have dates from 1 to 31. I used formula to populate dates from 1 to 31.
the problem comes in when a month has 28, 29,30 days that means that in the last three columns the dates goes over to the next month.
Is there a formula I can use to make those cells blank if it goes over to next month. (feb ends in 28 and theefore the rest of the column dates needs to be blank)
hope the explanation was clear enought

 

[jtakw]

Hi,

Assuming you have a Real Date in A1.

Use B5 formula copied across if you Only need a number representing the day of the month.
Use B6 formula copied across if you Require Real Dates. You can format this row as d to the day Only, if you like.

Book3.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
1	February 2022
2
3
4
5		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28
6		2/1/2022	2/2/2022	2/3/2022	2/4/2022	2/5/2022	2/6/2022	2/7/2022	2/8/2022	2/9/2022	2/10/2022	2/11/2022	2/12/2022	2/13/2022	2/14/2022	2/15/2022	2/16/2022	2/17/2022	2/18/2022	2/19/2022	2/20/2022	2/21/2022	2/22/2022	2/23/2022	2/24/2022	2/25/2022	2/26/2022	2/27/2022	2/28/2022
Sheet1070

Cell Formulas
Range	Formula
B5:AF5	B5	=IF(COLUMNS($B5:B5)>DAY(EOMONTH($A1,0)),"",COLUMNS($B5:B5))
B6:AF6	B6	=IF(COLUMNS($B5:B5)>DAY(EOMONTH($A1,0)),"",EOMONTH($A1,-1)+COLUMNS($B5:B5))

 

[oblix]

Wow that totally worked
Thank you for quick response

 

[jtakw]

You're welcome, thanks for the feedback.