Help if possible. bgjon5 <bgjon5.2b1wws_1153075212.6563[ at ]excelforum-nospam.com> 16.07.2006 18:37:41 Sorry if this is posted in the wrong fourm but heres what I am trying to do: I need to set up a spreadsheet, i've got the basics down (I think) but am having some problems what i am trying to do is: I need to track how long a for intance a trailer has been in my yard so I set up a basic spread sheet with dates say in A1 I have the date the trailer comes in say 7/15/06 and then I need a automatic function to add a current date everytime I open the sheet again, say in like C1 and I need the dates to subtact eachother so if I open it today (7/16/06) it will show 1 (as the number of days its been here) i set up a =Today() macro but it won't let me subtract from it it keeps giving me like 1/01/1900 or something.. I hope this isn't too confusing..... and after 15 days I need it to start multiplying by $15 . If you can help it would be appreciated if not just tell me to bug off LOL. Jon -- bgjon5 ------------------------------------------------------------------------ bgjon5's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36410 View this thread: http://www.excelforum.com/showthread.php?threadid=561866

Re: Help if possible. VBA Noob <VBA.Noob.2b1xls_1153076108.6111[ at ]excelforum-nospam.com> 16.07.2006 18:52:25 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?action=getinfo&userid=33833 View this thread: http://www.excelforum.com/showthread.php?threadid=561866

Re: Help if possible. "Roger Govier" <roger[ at ]technologyNOSPAM4u.co.uk> 16.07.2006 20:14:30 Hi Your answer was correct, it is just the formatting of cell C1. Format>Cells>General and your result of 1/01/1900 will show as 1 In cell D1 =IF(C1>=15,C1*15,"") Format the cell as Currency -- Regards Roger Govier "bgjon5" <bgjon5.2b1wws_1153075212.6563[ at ]excelforum-nospam.com> wrote in message news:bgjon5.2b1wws_1153075212.6563[ at ]excelforum-nospam.com... [Quoted Text] > > Sorry if this is posted in the wrong fourm but heres what I am trying > to > do: > > I need to set up a spreadsheet, i've got the basics down (I think) but > am having some problems what i am trying to do is: > > I need to track how long a for intance a trailer has been in my yard > so > I set up a basic spread sheet with dates say in A1 I have the date > the > trailer comes in say 7/15/06 and then I need a automatic function to > add a current date everytime I open the sheet again, say in like C1 > and > I need the dates to subtact eachother so if I open it today (7/16/06) > it > will show 1 (as the number of days its been here) i set up a =Today() > macro but it won't let me subtract from it it keeps giving me like > 1/01/1900 or something.. > > I hope this isn't too confusing..... > > and after 15 days I need it to start multiplying by $15 . If you can > help it would be appreciated if not just tell me to bug off LOL. > > > Jon > > > -- > bgjon5 > ------------------------------------------------------------------------ > bgjon5's Profile: > http://www.excelforum.com/member.php?action=getinfo&userid=36410 > View this thread: > http://www.excelforum.com/showthread.php?threadid=561866 >

Re: Help if possible. VBA Noob <VBA.Noob.2b228g_1153082109.1823[ at ]excelforum-nospam.com> 16.07.2006 20:33:22 Roger I agree he needs to seperate the two formulas into two columns to make any sense. VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33833 View this thread: http://www.excelforum.com/showthread.php?threadid=561866

Re: Help if possible. bgjon5 <bgjon5.2b23e5_1153083609.3477[ at ]excelforum-nospam.com> 16.07.2006 21:00:03 VBA Noob Wrote: > Hi, [Quoted Text] > > 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 Sorry maybe I confused you I want to show a dollar value after the total of days but I only need the value to multiply after 15 days for instance the trailer came in on 6/30/06 its now 7/16/06 so 16 days have went buy so the total would be $15 then tomorrow it would be $30 and so on also I ran into another problem but I'll wait to ask that LOL.. sorry guys if I am being a pain. -- bgjon5 ------------------------------------------------------------------------ bgjon5's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=36410 View this thread: http://www.excelforum.com/showthread.php?threadid=561866

Re: Help if possible. VBA Noob <VBA.Noob.2b3u4h_1153164912.2915[ at ]excelforum-nospam.com> 17.07.2006 19:35:10 Try this =IF(C1-A1+1>15,TEXT(((C1-A1+1)-15)*15,"$###,###"),TEXT(C1-A1+1,"###,###")&" Days") VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33833 View this thread: http://www.excelforum.com/showthread.php?threadid=561866

Re: Help if possible. bgjon5 <bgjon5.2b3yiu_1153170612.8476[ at ]excelforum-nospam.com> 17.07.2006 21:05:20 VBA Noob Wrote: > Try this [Quoted Text] > > =IF(C1-A1+1>15,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?action=getinfo&userid=36410 View this thread: http://www.excelforum.com/showthread.php?threadid=561866