I worked out the formla but noe need to know how to stop an if fuction from
show false if it don't match and leave what was there in the first place.

"Dreamstar_1961" wrote:

what I'm trying to do is copy a cell to a different cell based on date (day),
A1 34 b1 todays date c1 copys only if todays say = 15th
I thought the formula woul look something like this =if(today()=day(15),a1,"")
but that don't work.
is this possiable at all?

Thanks