Hi there,
I am trying to achieve the following.
In cell A1 say, I will have a drop down list for months of the current year. Lets choose October for our example.
IN cell A2 I would like to show the date of the first day of that month. i.e. 01/10/2011 and
in A3 I require the second date of that month ie 02/10/2011. A4 will contain 3rd date and so on until the last day of the month.
Now when I change the month from the drop down list, all the dates in colum A change automatically even though some months have a diffrent number of days.
ANy help would be appreciated. Thanks
Bookmarks