Hi,

I am a newbie to VBA.
Can any one help me in answering this question?

(Q4)
The following worksheet contains some dates in cells A2:A9.

Date New Display Leap Year
2/5/2004
28/09/2000
12/8/2001
23/07/1976
31/12/1836
15/03/2084
8/10/2800
22/02/1736

Write a sub procedure to perform the following operations:
(a) Display the dates in the column B in the form, for exampl
02/ May/2004,
(b) Indicate whether the year is a leap year in column C wit
Yes or No.

Conditions for a year to be a leap year:
A year is a leap year, if it is divisible by 4;
But, it is not a leap year, if it is divisible b
100;
However, it is a leap year, if it is divisibl
by 400


Thank You Very Much!
Lexie

--
lexie
-----------------------------------------------------------------------
lexiez's Profile: http://www.excelforum.com/member.php...fo&userid=1498
View this thread: http://www.excelforum.com/showthread.php?threadid=26603