hi
no such formula exists. formulas return values, they can not perform actions
such as copy, past or covert itself to hard values when a conditions is met.
to do this requires code, either built in excel code (mouse and keyboard
caused excel code to run) or user defined add on code i.e. a macro.

regards
FSt1

"Lim" wrote:

Hi,

I need help to know whether there is a formulae which I can paste value
after doing an average calculation.

For example the cell will calculate the average of a series of numbers and
will paste value when the specify date is reached.

I do not wish to use a macro function, thanks!