Hi,

Not sure why you want to mox days with $ but this should do the trick

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

I added Days and $ text so you can tell which is which

VBA Noob


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