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