Try somehting like:

=IF(MONTH(TODAY())<8,YEAR(TODAY()),YEAR(TODAY())+1 )

-or-

If Month(Now) < 8 Then
Text1 = Year(Now)
Else
Text1 = Year(Now) + 1
End If


"Greg B" wrote:

I want to put a text box which suggests the year.

I would like it to suggest the current year until after july when the
program will need to suggest next year.

Thanks in advance

Greg