Q-1.Write a VBA Program to display the current date in the following format.
Sample output: 12:00 AM Sep 5, 2014.
Q-2.Write a VBA Program to display the current date in the following format.
Sample output: 05/09/2014
Q-3.Write a VBA Program to extract the year from the current date.
Q-4.Write a VBA Program to get the current date in the following format.
Sample date : 2014-09-04
Output : September 4, 2014
Q-5.Write a VBA Program to calculate the age in year.
Q-6.Write a VBA Program to get the last day of the current year.
Q-7.Write a VBA Program to get the first day of the current year.
Q-8.Write a VBA Program to display the last day of the month (in datetime format) three months before the current month.
Q-9.Write a VBA Program to display the first day of the month (in datetime format) three months before the current month.
Sample current date : 2014-09-03
Expected result : 2014-06-01
Q-10.Write a VBA Program to get the mid day of the current year.