Change cell according to date
 

Hi,

In cell H1 i have a value that changes from time to time. In column A i
have dates. Certain cells in column E have the value of H1 others are blank.
If the date in column A has passed i would like the corresponding cell in
column E to remain the unchanged but future values of column E to alter
when a new value is entered in H1.
Its akin to a loan scenario where future payment alter but past dont.
Hope you understand my meaning.
Thanks