Thanks daddy. Now what I'm missing is for a way that the 5 will remain there
through the end of the work period, not just there for that 1 day. Its a
period of less than 1 month, but the dates vary.

"daddylonglegs" wrote:


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