Sorry
Gettin confused, I have uploaded an example
F1=01/11/2008
AI=30/11/2008
I know that the first day of the month will always be in F1
So A1=F1
C2=DATE(YEAR(A1),MONTH(A1)+1,0)
C2 is now 30/11/2008
I need to search from F1 to AI to find the column that 30/11/2008 is in
I then need to get all the values from that column and place them in A23 to A42
So i need to get the values from AI2 to AI21 and copy them to A23 to A42
The column position of the last day of the month changes every .month
Bookmarks