preseb
10-04-2012, 05:12 AM
I need help with a section of a macro that I am putting together. It involves date ranges and bringing back the assigned month.
On one worksheet, I have a list of dates that cover over a year’s time. This sheet is labeled “FY2013”. In another worksheet (labeled “Macro”) I have setup three columns. The month, start date and end date.
The reason is that if I am looking at the month of July, we are not identifying it as 7/1-7-31. It may be 7/1 – 8/6.
WS FY2013 Returned Value WS Macro – Month WS Macro – Start WS Macro–End
7/23 July July 7/1 8/6
8/1 July August 8/7 9/1
8/4 July September 9/2 9/29
8/7 August October 9/30 10/27
The Returned Value is what I am looking to accomplish
I uploaded a sample
Thanks
On one worksheet, I have a list of dates that cover over a year’s time. This sheet is labeled “FY2013”. In another worksheet (labeled “Macro”) I have setup three columns. The month, start date and end date.
The reason is that if I am looking at the month of July, we are not identifying it as 7/1-7-31. It may be 7/1 – 8/6.
WS FY2013 Returned Value WS Macro – Month WS Macro – Start WS Macro–End
7/23 July July 7/1 8/6
8/1 July August 8/7 9/1
8/4 July September 9/2 9/29
8/7 August October 9/30 10/27
The Returned Value is what I am looking to accomplish
I uploaded a sample
Thanks