How do i get excel to automatically put dates into a cell on a 4 week bases?

David

New member
I am wanting to find out how much I would get paid before tax and have made an excel spreadsheet. However I have come across a problem.

I get paid on a 4 weekly bases. Instead of adding all the dates manually is their anyway telling excel to work out the date 4 weeks on from previous cell?

I have entered 4 dates in, all 4 weeks ahead of previous cell highlighted them all and started dragging across however it just repeats what I have written! AGGGHHHHH!
 
Back
Top