VBA Noob Wrote:
Try this

=IF(C1-A1+115,TEXT(((C1-A1+1)-15)*15,"$###,###"),TEXT(C1-A1+1,"###,###")&"
Days")

VBA Noob


God your good!

Bows down LOL

works perfect Thanks !


--
bgjon5
------------------------------------------------------------------------
bgjon5's Profile: http://www.excelforum.com/member.php...o&userid=36410
View this thread: http://www.excelforum.com/showthread...hreadid=561866