# Cannot hide Feb 29th if not in use

#### Puggwash

##### Board Regular
I have a Calander set in Excel 2007 for each month of the Year, which starts from Apr-Mar.

On the Calander for Feb, I have Rows 'D7' to 'AF7' that will show the days for Feb (inc Feb 29th).

What I want is, if it is not a Leap Year, how do I hide 'AF7' so that it does not show up but will show if it is a Leap Year?

March set up runs Ok so I do not need to amend anything there if feb 29th shows but is not a Leap Year.

Hope someone can help.

Many Thanks

Pugg.

### Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

#### Joe4

How is the range 'D7' to 'AF7' being populated with the dates? By formulas? By VBA code?

#### cummingsea

##### Active Member
Hi Puggwash, I have posted a calendar on Microsoft Template website, here's the link
http://office.microsoft.com/en-us/FX102785691033.aspx?pid=CL100569831033 on top of the page click on Templates,then click on Calendars, click on 2008 Calendars, click on page 5 and scroll down tell you see the one named Calendar with Holidays Provided by Eugene Cummings it may give you some ideas I created it using a array formula so if February has 28 days that's all it will show but if it has 29 days then It will show all 29 days. Plus it has a formula that will automaticlly change the Calendar every year 2009, 2010, 2011 and so on.

#### Puggwash

##### Board Regular
Joe4, I have it using Formulas.
'D7' to 'AF7' is just written as No 1 to 29 but uses the formulas from 'D4' to 'DF4' (D4 ==DATE(YEAR(Jan!D4),MONTH(Jan!D4)+1,DAY(Jan!D4)) and E4 to DF4 uses =F4+1 or G4+1 etc till it reaches DF4 that uses = DE4+1.

D5 to DF5 use (=WEEKDAY(D5) and so on till it reaches DF5.

D6 to DF6 use (=VLOOKUP(D5,Codes!\$B\$25:\$C\$32,2,FALSE) all the way to DF6.
The code is in a sheet that has 1=Sun, 2=Mon and so on.

Can you help with this information.

cummingsea, I cannot open the file you have mentioned. Is there anyway of obtaining it or helping with the above information I have sent.

Many Thanks

Pugg.

#### Puggwash

##### Board Regular
cummingsea, I will send you my email to your private section so it is not used by other people.

Many Thanks

Pugg

#### cummingsea

##### Active Member
File has been sent.

#### barry houdini

##### MrExcel MVP
'D7' to 'AF7' is just written as No 1 to 29 but uses the formulas from 'D4' to 'DF4....

Not particularly clear to me, what does "uses the formulas" mean? do cells D7:AF7 have formulas or just numbers?

#### Puggwash

##### Board Regular
Barry,

All I want is to hide AF7 if it is not 29th Feb. If it is 29th, it will show up.

The formulas as mentioned are set to display the dates day (Sun - Sat). I don't need to to use these, only to hide AF7 if Feb only has 28 days (29th is hidden).

I Wanted to know if there was an easy way to hidethe above, possibily using Conditional Formatting. Or is there something else out there, that can be used to do the same?

Pugg

#### Joe4

Sure, you can use Conditional Formatting, and if the date does not equal February 29, change the color of the text to be white so that it matches the background and essentially becomes "invisible".

Replies
2
Views
382
Replies
1
Views
206
Replies
1
Views
317
Replies
11
Views
1K
Replies
2
Views
387

1,191,718
Messages
5,988,264
Members
440,146
Latest member
rgomes8

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back