date

[carday]

i have created a formula that inputs data when today's date = a predefined date
eg =IF((TODAY()=C10),E5,0)
C10 being the predefined date E5 being data if query = true,
what can i add to this formula to stop the data changing to 0 when today is greater than C10 and work has been saved

 

[tactps]

Your formula is set to use 0 where the if statement is false (hence your ",0".

If you want it to be blank, for instance, use:
=IF((TODAY()=C10),E5,"")

or :
=IF((TODAY()>=C10),E5,"")

 

[Dutchy]

Can't you use

=IF((TODAY()>=C10),E5,0)

?