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?

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.

Leave what was where in the first place? You can't have a formula and a
value in the same cell.... if you have a formula, it must generate the
cell's content.

Rick