View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dreamstar_1961 Dreamstar_1961 is offline
external usenet poster
 
Posts: 43
Default copy cell based on date

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