if month(dtpicker.value)=8 then
variable1 = right(year(dtpicker.value),2) & "/" & _
right(year(dtpicker.value)+1,2) & " Grant Year"
else
variable1 = right(year(dtpicker.value)-1,2) & "/" & _
right(year(dtpicker.value),2) & " Grant Year"
endi

--
MattShoreso
-----------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...nfo&userid=347
View this thread: http://www.excelforum.com/showthread.php?threadid=56325