I AM LOOKING FOR A VERY SIMPLE REPLY PLEASE.

[ChrisJAT]

I wish to set a value of a specific cell to 0, whenever it is today's date.

[#2]

@ChrisJAT 

Please tell us in more detail what you want to happen.

[#3]

I wish to set a value of 0 in a cell, when it is todays date =today()

[#4]

if date is =today() then set value to 0

[#5]

That request is circular. You would need to introduce a second column and work with that instead. So column A are dates unaltered. Column B =IF(A:A=TODAY(),0,@A:A). Whatever follows has to key off B.

[#6]

i understand the idea of a second column, but the rest is all gibberish to me. sorry
I am geting a result that looks like a telephone number

[#7]

column A is daily date
column T contains result of formula just given

column s contains the value of 25 (daily)
on todays date i wish column s to be reset to 0
therefore if column t=0 then column s=t
there must be a simpler way to automatically transfer the value of 0 into an existing cell

[#8]

IN OLD FASHIONED BASIC CODE
If cell a1= 0 then let cell b1 =0
=DAYS(A1,TODAY()) to give value of 0

if it can be done so simply in BASIC coding, then why is it so complicated in MS Excell?