Hello. What is a good formula that will start at Jan 2010 (for example) and continue as I drag the formula across the columns...up to Dec 2013 for example. Danks.
Hello. What is a good formula that will start at Jan 2010 (for example) and continue as I drag the formula across the columns...up to Dec 2013 for example. Danks.
If A1 has a date, in B1 put the formula:and drag across.Formula:Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
You can use the Fill, Series. Enter the start date in the cell of your choice. Select that cell and then go to Fill, Series on the Home tab. Select Rows, Date, Month and Step Value of 1 and in the Stop Value enter Dec-15
All the months will be filled in.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
@newdoverman: ah, maybe I misunderstood the requirement
@TMShucks: maybe I did...he did say "drag the formula across"....it's been a very long day
formula driven result for months going across
assuming a1 is start cell
Formula:Please Login or Register to view this content.
drag across
Last edited by humdingaling; 12-11-2013 at 08:29 PM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks