cell B1 contains the date "7/1/12"
cell D1 contains the formula =B1+1 and it correctly displays, "7/2/12".
When I copy that formula in to cells F1, H1, etc., it does not carry the math out even though the relative references appear correct.
I have several identical spreadsheets and this is the only one with a problem and I just cant figure it out. I will attach the affected spreadsheet for reference.
you have the calculation set to manual
and btw you dont need to use the sum() for this, just B1+1 will do.
also, merge and center is never a good option to use, it makes references tricky...rather use center across selection
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
just put the date in ? not =DATE(2012,7,1) just 1/7/2012and btw set calculation to automatic in options format cell to sh0w date format you want
"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. I knew it was probably something simple, just couldn't figure out how to get there.
Thanks again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks