wdwilliams
New Member
- Joined
- Sep 9, 2015
- Messages
- 2
I am making a payroll reporting worksheet and want the top of each column to have "WE" and the date of every other Friday in the cell. i.e.[TABLE="width: 252"]
<tbody>[TR]
[TD="class: xl67, width: 84"]WE 09/11/15[/TD]
[TD="class: xl67, width: 84"]WE 09/25/15[/TD]
[TD="class: xl66, width: 84"]WE 10/09/15[/TD]
[/TR]
</tbody>[/TABLE]
My problem is how can do I get the date to fill every other week when I drag it out? I have tried multiple formulas but having the text in the cell has really got me stumped.
Thanks in advanced.
<tbody>[TR]
[TD="class: xl67, width: 84"]WE 09/11/15[/TD]
[TD="class: xl67, width: 84"]WE 09/25/15[/TD]
[TD="class: xl66, width: 84"]WE 10/09/15[/TD]
[/TR]
</tbody>[/TABLE]
My problem is how can do I get the date to fill every other week when I drag it out? I have tried multiple formulas but having the text in the cell has really got me stumped.
Thanks in advanced.