You can change your formula to create a null string.

=IF(A5="","",myfunction(arguments))

If you are into macros, you could use a Change Event macro to create the formula and insert the date.
http://www.mvps.org/dmcritchie/excel/event.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"tml41dmb" wrote in message ...
I'm setting up a profit spreadsheet with actual and quota figures. What
function do I use so that each month I can input the data and the function
will display everything else, without displaying wrong #s in the meantime.
ie...Just leave YTD function cell blank until 2006 March's Actual has been
put in. Sorry for the horrible wording, it's my 1st time posting on here.
Thanks.