Suggestions requested for vacation planning Excel spreadsheet

[echo144000]

I have a cell in a spreadsheet that contains a number of vacation
days. I would these vacation days to turn to zero in the same cell
after June 30th. I'm VB illiterate...is there an IF, THEN formula (or
any other) that would work for this?

 

[Tom Ogilvy]

=if(today()>DateValue("Jun 30, 2005"),0,current formula)