Fortnightly Excel Formula

[Fauna]

I'm very new to excel and this question is probably redundant to all of you, but it needs to be asked.

I keep track of some tenants payments and would like to just have to input the payment date and payment confirmed not. The clip below is what the spreadsheet would look like. Unfortunately this template has been given to me by a superior in my department who doesn't want the layout changed.

I would just like to have column 2 pre-filled with the fortnight dates - How do I do this ?

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: -webkit-right"]04/04/2014[/TD]
[TD]04/04/2014 - 17-04/2014[/TD]
[TD]129.01[/TD]
[TD]Payment Confirmed[/TD]
[/TR]
[TR]
[TD]17/04/2014[/TD]
[TD]18/04/2014 - 01/05/2014[/TD]
[TD]129.01[/TD]
[TD]Payment Confirmed[/TD]
[/TR]
[TR]
[TD]02/05/2014[/TD]
[TD]02/05/2014 - 15/05/2014[/TD]
[TD]129.01[/TD]
[TD]Payment Confirmed[/TD]
[/TR]
</tbody>[/TABLE]

 

[BrianMH]

Put this formula in the column and drag it down. Adjust the formula to point to the correct row/column as needed.


=TEXT(A1,"DD/MM/YYYY") &" - " & TEXT(A1+13,"DD/MM/YYYY")

 

[Peter_SSs]

Welcome to the MrExcel board!

If your column A values are correct, then you cannot use those as Brian has done since the first two are 13 days apart and the second two are 15 days apart.
In that case you could enter the first fortnightly value in column B then use this formula copied down.

Excel Workbook
	B
1
2	04/04/2014 - 17/04/2014
3	18/04/2014 - 01/05/2014
4	02/05/2014 - 15/05/2014
5	16/05/2014 - 29/05/2014
6	30/05/2014 - 12/06/2014
Fortnights

 

[Fauna]

Thanks for this. I'll have a play around over the weekend and see how it works. The help has been amazing

 

[Fauna]

Thanks Peter!

I managed to have a try on my lunch break and it worked !!!

Thanks also Brian for your help!