Cannot hide Feb 29th if not in use

[Puggwash]

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.

 

[Joe4]

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

 

[cummingsea]

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]

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.

 

[cummingsea]

I could email it to you around noon time I have a 10:00AM Doctors appointment, I would need your email address.

 

[Puggwash]

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

Many Thanks

Pugg

 

[cummingsea]

File has been sent.

 

[barry houdini]

'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]

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".