 You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
This seems really basic formula which I have achieved in other versions.
Basically I want a long the top dates going up weekly starting from the 3rd October so therefore the next date would be 10th.
Any idea the easiest way to do this?
Just put the first two dates in the range in then highlight both and drag from bottom right. That should do it.
A1 = 03/10/16
B1 = A1 + 7
C1 = B1 + 7
etc
None of those solutions work.
Allthepies - I get value error
Funkmasterp - I get it going then it ascends 2017 2018 2019
the funkmaster's suggestion definitely works on my version
are your dates formatted as: 3/10/2016 ..... 10/10/2016 ?
Works in my 2013, eg 3 Oct 2016, 7 Oct 2016, then right click and drag bottom right corner (as funkmaster)
I got it formatted correct I type 3/10/2016 and 10/10/2016 then the next ones are 2017
If your settings are for some reason mis-set as US, then the dates you typed are 10th March 2016 and 10th October 2016, so if you "dragged them out" then excel would assume you want dates 7 months apart
However, if you're using the "+7" formula you ought to be ok.
try typing the date as 10-Mar-16 and see which way it formats it when you hit return - if it goes to 3/10/16 then the settings have gone all merkin on you.
Ah sorted. Much better using Oct instead of numbers
What's the actual date you're gettng? Format the cell to display (for example) "10 October 2016" rather than 10/10/2016 so you can see what month excel thinks it's using.
Most obvious thing to me is excel thinks you're going 10th March 2016-> 10th October 2016 and is carrying on that format so the next cell is 10th May 2017 (7 months later) which would show as 10/05/2017 or 05/10/2017 depending on formatting.
Edit, cross posted.
Cheers guys