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,"")
Bookmarks