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


Co

--
colofnatur
-----------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...fo&userid=3435
View this thread: http://www.excelforum.com/showthread.php?threadid=56325