Date function -

[tommacca]

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

 

[FormR]

Here is one option:

Excel Workbook
	A	B	C	D
2	01/01/2014		01/01/2014	31/01/2014
3	08/04/2014		01/02/2014	28/02/2014
4			01/03/2014	31/03/2014
5			01/04/2014	07/04/2014
Sheet1

 

[Peter_SSs]

I have C2 as a stand-alone formula and C3 and D2 copied down.

Excel Workbook
	A	B	C	D
1			Start	End
2	5/01/14		5/01/14	31/01/14
3	8/04/14		1/02/14	28/02/14
4			1/03/14	31/03/14
5			1/04/14	7/04/14
6
7
Dates