Hello everyone,
I am an excel noob! So thanks in advance for any advice.
I have column A which has the same date (mm/dd/yy) repeated 48 times.
After 48 times, I would like to increment the day by 1 and repeat another 48 times.
Am I able to do this? I'd rather not have to copy/paste the dates and modify them manually.
Thanks in advance
with 48 same dates in a1:a48 then put in a49
=a1+1 fill down as far as you need
another way would be
wherever you want to start from put
="02/21/2012"+CEILING(ROWS($A$1:A1)/48,1)-1 fill down
or even put the start date in another cell out of the way say m1
=$m$1+CEILING(ROWS($A$1:A1)/48,1)-1
remember to format cell as date
Last edited by martindwilson; 12-02-2013 at 06:22 PM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Thank you so much the following worked perfectly.
="02/21/2012"+CEILING(ROWS($A$1:A1)/48,1)-1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks