Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]() 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 |