I would like to create a template. This template would have 2 input cells - one to enter a month and one to enter a year (e.g. February and 2000).
From these 2 cells I would like to automatically create a column of dates, from the 1st of that month through to the last day of that month (e.g. 1st Feb 2000, 2nd Feb 2000, through to 29th Feb 2000).
I've managed to create the first day of the month using DATE and the last day of the month using EOMONTH. But this doesn't really get me where I need to go! Any ideas please?
EXAMPLE:
Enter month: 2
Enter year: 2000
1/02/2000
2/02/2000
3/02/2000
4/02/2000
5/02/2000
6/02/2000
7/02/2000
8/02/2000
9/02/2000
10/02/2000
11/02/2000
12/02/2000
13/02/2000
14/02/2000
15/02/2000
16/02/2000
17/02/2000
18/02/2000
19/02/2000
20/02/2000
21/02/2000
22/02/2000
23/02/2000
24/02/2000
25/02/2000
26/02/2000
27/02/2000
28/02/2000
29/02/2000
Bookmarks