LinkBack URL
About LinkBacks
stephme55 
Hello. I have three dates, 1/1/2016, 2/1/2016, 3/1/2016 and when I drag it across a table it doesn't fill the series as 4,5,6,7 etc. but just repeats the pattern. How can I get it to keep adding months?
Hello. I have three dates, 1/1/2016, 2/1/2016, 3/1/2016 and when I drag it across a table it doesn't fill the series as 4,5,6,7 etc. but just repeats the pattern. How can I get it to keep adding months?
=EDATE("1/1/16",COLUMNS($A:A)-1)
will do that.
Last edited by Glenn Kennedy; 10-28-2016 at 01:14 PM. Reason: Significant typo!!!!
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
To make it row/column delete proof... and assuming the sequence starts in (say) B4
=EDATE("1/1/16",COLUMNS($B$4:B4)-1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks