Ok, I see what you are saying. It actually takes the value and past it
to the footer. It does not update it when the cell is updated. Is this
correct?

I would like the footer to show an As of date that I have in a cell.
The As of date is not the same as Today, so I can not use Now()

Any solution on how to refresh the information of the cell?
Thanks