Hi guys,
I am trying to create either a macro or formula that will do the following;
reference the date in A2 and a3
Output the start date to the last day of the month but the date range could be 3 months so it would need to the output the date of the 1st to the last day of each month or the end date if thats before the end of the month
ie a2 = 01/01/14
a3 = 08/ 03/2014
so it would output (each date in separate cell)
01/01/2014 - 31/01/2014
01/02/2014 - 28/02/2014
01/03/2014 - 07/03/2014
I am trying to create either a macro or formula that will do the following;
reference the date in A2 and a3
Output the start date to the last day of the month but the date range could be 3 months so it would need to the output the date of the 1st to the last day of each month or the end date if thats before the end of the month
ie a2 = 01/01/14
a3 = 08/ 03/2014
so it would output (each date in separate cell)
01/01/2014 - 31/01/2014
01/02/2014 - 28/02/2014
01/03/2014 - 07/03/2014