Hide cells if month different from previous cell

[Pitbull_Raven]

Hi.

I have searched but didn't find anything similar. Found some posts about dates but nothing like what I am searching for.

My question:

We work with a worksheet to register quality issues occurred during a certain month. The sheet is printed out a few days before the start of the new month.

In my sheet I have cell H1 where I type in the first day of the month, say 01-11-2010 and formated so it shows only the month (November).

Updating this cell causes the cells from B5 to B35 to change accordingly. The problem is the last cell displays 01-12-2010. I have to either delete or format the cell out. How can I hide cells with month different from H1 automatically? Problem is even worse in February so the solution cant be something like "hide if different from previous cell". Has to be more along the lines of "hide if different from H1" I guess.

Appreciate any help!!! Thanks!

 

[Andrew Poulsom]

What formula(s) are you using in B5:B35?

 

[Pitbull_Raven]

What formula(s) are you using in B5:B35?

B5 is =H1
B6 to B35 is =B5+1; =B6+1; etc...

Can change if needed.

 

[Andrew Poulsom]

Try in B6:

=IF(MONTH(N(B5)+1)=MONTH(H$1),N(B5)+1,"")

copied down.

 

[Pitbull_Raven]

Try in B6:

=IF(MONTH(N(B5)+1)=MONTH(H$1),N(B5)+1,"")

copied down.

**** dude! That was fast and perfect

Perfect job. Thanks!

 

[AlphaFrog]

Excel Workbook
	B
5	February
6
7	February 1, 2010
8	February 2, 2010
9	February 3, 2010
10	February 4, 2010
33	February 26, 2010
34	February 27, 2010
35	February 28, 2010
36
37
38
...

Cell Formulas
Range	Formula
B7	=B5
B8	=$B$5+ROW(1:1)
B9	=$B$5+ROW(2:2)
B10	=$B$5+ROW(3:3)
B33	=$B$5+ROW(25:25)
B34	=IF(MONTH($B$5+ROW(26:26))=MONTH($B$5),$B$5+ROW(26:26),"")
B35	=IF(MONTH($B$5+ROW(27:27))=MONTH($B$5),$B$5+ROW(27:27),"")
B36	=IF(MONTH($B$5+ROW(28:28))=MONTH($B$5),$B$5+ROW(28:28),"")
B37	=IF(MONTH($B$5+ROW(29:29))=MONTH($B$5),$B$5+ROW(29:29),"")
B38	=IF(MONTH($B$5+ROW(30:30))=MONTH($B$5),$B$5+ROW(30:30),"")

 

[Pitbull_Raven]

Excel Workbook
	B
5	February
6
7	February 1, 2010
8	February 2, 2010
9	February 3, 2010
10	February 4, 2010
33	February 26, 2010
34	February 27, 2010
35	February 28, 2010
36
37
38
...

Cell Formulas
Range	Formula
B7	=B5
B8	=$B$5+ROW(1:1)
B9	=$B$5+ROW(2:2)
B10	=$B$5+ROW(3:3)
B33	=$B$5+ROW(25:25)
B34	=IF(MONTH($B$5+ROW(26:26))=MONTH($B$5),$B$5+ROW(26:26),"")
B35	=IF(MONTH($B$5+ROW(27:27))=MONTH($B$5),$B$5+ROW(27:27),"")
B36	=IF(MONTH($B$5+ROW(28:28))=MONTH($B$5),$B$5+ROW(28:28),"")
B37	=IF(MONTH($B$5+ROW(29:29))=MONTH($B$5),$B$5+ROW(29:29),"")
B38	=IF(MONTH($B$5+ROW(30:30))=MONTH($B$5),$B$5+ROW(30:30),"")

Also did the trick. Thanks!