Auto Data Entry

[The Wolf]

I have checked the help section for this and come up empty.

Is there a way to auto entry data in Excel?

E.g. If today() is equal to or greater than 5/15/04 then enter $50 in cell
b5

 

[Domenic]

I have checked the help section for this and come up empty.

Is there a way to auto entry data in Excel?

E.g. If today() is equal to or greater than 5/15/04 then enter $50 in cell
b5

Try,

=IF(TODAY()>=DATEVALUE("5/15/2004"),50,"")

Hope this helps!

 

[The Wolf]

Try,

=IF(TODAY()>=DATEVALUE("5/15/2004"),50,"")

Hope this helps!

Thanks! Is there a way to have it show $0 if the date is less than the 15th?

 

[JE McGimpsey]

Thanks! Is there a way to have it show $0 if the date is less than the 15th?

Change "" to 0

 

[The Wolf]

Change "" to 0

Thank you!