OK, so you want A23 to remain blank until 23/10/2007?

How about this in A23

=IF(K22=TODAY(),K22,"") then when A23 gets to 23/10/2007, then it will display in A23, before or after that date it displays blank

or if you want A23 to display even after 23/10/2007, then you could use this

=IF(K22<=TODAY(),K22,"")