• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

help in excel formula

Example: in A1 Cell we write "='21-05-24'!M94" and in A2 cell "='21-05-24'!M96"

So, i want in cell A2 ='21-05-24'!M96 auto plus 2 from cell A1.
is this possible
 
now i R&D on this formula

=LEFT(FORMULATEXT(A1), LEN(FORMULATEXT(A1))-2)&RIGHT(FORMULATEXT(A1),2)+2

but now its the "='21-05-24'!M96" but not showing the value on this link cell
 
Back
Top