You can extract that 10 out of the =10*10 like this...
=RIGHT(LEFT(FORMULATEXT(REFERENCED CELL WITH FORMULA),3),2)
That would pull the formula built into the cell and then give you first the left 3 and then the right 2 leaving you with 10
Now with all that said, would you mind posting a small book/sample file so that I can see the dates, formats etc...
Unless of course that formula gives you what you need
Bookmarks