Do you mean you want a formula to return 5 on the last day of a quarter
only? If so try

=IF(DAY(NOW()+1)+MOD(MONTH(NOW()),3)=1,5,"")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=521401