1- I have a column of dates (A100:A250).
In B1:B30 I need the first 30 dates, in C1:C30, the next 30 and so on, in D, E and F.
I wrote in B1 "=A100", in B2 "=A101"..... B30 "=A130".
I can go to C1 and manually write "=A131", copy down; then in D1 "=A161" and so on.
Looking for a way (hope there is one) to avoid writing manually in C1, D1 and so.
I tried writing in C1 "=B130+1" but, of course if, for example, the date in B30/A130 is 4/20 and in B31/A131 is "4/26", it's giving me "4/21" (4/20+1).
2- In the above set up, if I erase one raw in the A1:A150, the corresponding "=" cell in the B1:F30 gives the #REF! error message.
I would like to be able to erase a raw and still keep the right (updated) dates in the B1:F30 range.
Any ideas anyone?
Thanks in advance and appreciate any help.
Ted
Bookmarks