copy cell based on date

D

Dreamstar_1961

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
 
R

Rick Rothstein \(MVP - VB\)

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?
Click to expand...

TODAY is a date and DAY(15) is an error. You need to apply the DAY function
to TODAY() and then see if that is 15...

=IF(DAY(TODAY())=15,A1,"")

Rick
 
D

Dreamstar_1961

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.
 
R

Rick Rothstein \(MVP - VB\)

what I'm trying to do is copy a cell to a different cell based on date
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.
Click to expand...

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
 
Top