My formula does not recognise when it is a leap year. What do i need to add or use instead of?

[Steve T]

My formula does not recognise when it is a leap year.

The formula is used to hide dates, in my spreadsheet.

The formula is =IF(DAY(C$8+28)<>29,"",C$8+28)
What do i need to add or use instead of?

 

[6StringJazzer]

Please explain what you want your formula to do. What dates are you trying to hide? I think we need the big picture here.

 

[Steve T]

Please explain what you want your formula to do. What dates are you trying to hide? I think we need the big picture here.

Hi

I have a the spreadsheets showing each day of the month. All dates are formulated from c8, which holds the 1st date of the month. for the cells holding the 29th,30th and 31st of the months, I have the formula stated in the original post. The formula recognises when a particular month, only has 28,29,30 days and makes the cell blank. However, it doesn't seem to recognise when it is a leap year.

 

[Fluff]

How about

Fluff.xlsm
	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
8	01-Feb-24	02-Feb-24	03-Feb-24	04-Feb-24	05-Feb-24	06-Feb-24	07-Feb-24	08-Feb-24	09-Feb-24	10-Feb-24	11-Feb-24	12-Feb-24	13-Feb-24	14-Feb-24	15-Feb-24	16-Feb-24	17-Feb-24	18-Feb-24	19-Feb-24	20-Feb-24	21-Feb-24	22-Feb-24	23-Feb-24	24-Feb-24	25-Feb-24	26-Feb-24	27-Feb-24	28-Feb-24	29-Feb-24
Main

Cell Formulas
Range	Formula
D8:AE8	D8	=SEQUENCE(,DAY(EOMONTH(C8,0))-1,C8+1)
Dynamic array formulas.

 

[Steve T]

My formula does not recognise when it is a leap year.

The formula is used to hide dates, in my spreadsheet.

The formula is =IF(DAY(C$8+28)<>29,"",C$8+28)
What do i need to add or use instead of?

apologies guys. The formula I had does work. It would help if i'd checked the correct cell!

Thanks for the quick responses though